31st august drive in mumbai

posted
contact
randstad india
position type
permanent
apply now

posted
location
mumbai, maharashtra
function
Information Technology
position type
permanent
experience
5-8
reference number
58412
contact
randstad india

job description

31st august drive in mumbai

TCGDSRC01

ETL Developer

  • Experience in ETL tools like Pentaho/Informatica etc. in a Datalake/Datawarehouse project
  • Excellent development skills in SQL/PL SQL (Oracle, Teradata/Sybase)
  • Exposure in working in Unix/Linux environment
  • Exposure of working in ElasticSearch, GPDB, ORACLE
  • Understanding of concepts of Datalake, Datawarehouse
  • Understanding of concepts of Physical DataModel, Logical DataModel and Conceptual DataModel
  • Creation of Source to target Mapping,System Test Cases and Plan
  • Code Versioning, Change Management, Production Release Support
  • Excellent communication skills
  • Ability to work in a complex matrix environment
  • Self-motivated and a strong team player
  • Educational Qualifications : B.tech/BE
     
  • Manage data analysis and data integration of disparate systems.
  • Build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business.
  • Implement processes and logic to extract, transform, and distribute data across one or more data stores from a wide variety of sources.
  • Provide problem-solving expertise and complex analysis of data to develop business Intelligence integration designs.
  • Strong in DWH and Data Lake concept

3 to 8 years

12

TCGDSRC02

Spark

  • Excellent Communication Skills
  • Ability to work in a Complex matrix Environment
  • Self-motivated and a strong team player.
  • Bigdata-Hadoop, Big data - Pyspark, Bigdata-Python, Bigdata-Scala, Bigdata-Spark

 

Preferred Skills:

 

  • Bigdata->Python
  • Bigdata->Scala
  • Bigdata->Pyspark
  • Bigdata->Spark
  • Bigdata->Hadoop

 

Educational Requirements

  • Bachelor of Engineering

 

Knowledge of design principles and fundamentals of architecture Understanding of performance engineering Knowledge of quality processes and estimation techniques

Basic understanding of project domain

Ability to translate functional / non-functional requirements to systems requirements

Ability to design and code complex programs

Ability to write test cases and scenarios based on the specifications

Good understanding of SDLC and agile methodologies

Awareness of latest technologies and trends

Logical thinking and problem solving skills along with an ability to collaborate

Technical and Professional Requirements:

                                      

4 to 8 years

5

TCGDSRC03

Greenplum/PostgreSQL DBA

•        Excellent Greenplum architecture and database maintenance knowledge

•        Hands on experience with Greenplum database V6.X

•         Monitor data distribution to identify data skew, also monitor vacuum and analyze needed on objects

•         Resource queue design for multiple workload prioritizing

•         Manage segments, recover segments during segment crash

•         Manage GP backup using DD Boost/commvault and restore

•        Perform POCs on various restore methodologies

•        Excellent performance and troubleshooting skill

•        Manage database and client host connectivity using pg_hba.conf

•        Proficient with gpfdist for data loading

•        Excellent shell and sql skill for DBA tasks automation

•        Good knowledge on postgres to support greenplum database

•        Excellent analysing skill to retrieve, understand and analyse the greenplum logs

•        Assist application developer teams in design and performance tuning

•         Provide database support in day to day operation
Establish and advise users on database specific best practices

•        Develop and enhance databa

skills

SQL, Pentaho

qualification

B.E/B.Tech