Details:

Role Summary:

•ETL Developer is responsible for Design and Development of ETL Jobs which follow standards, best practices and are maintainable, modular and reusable.

•ETL Developer will analyze and review complex object and data models and the metadata repository in order to structure the processes and data for better management and efficient access.

•Working on multiple projects, and delegating work to Junior Analysts to deliver projects on time.

•Training and mentoring Junior Analysts and building their proficiency in the ETL process.Job Duties:

•Preparing mapping document to extract, transform, and load data ensuring compatibility with all tables and requirement specifications.

•Experience in ETL system design and development with Talend / Pentaho PDI is essential.

•Create quality rules in Talend.

•Tune Talend jobs for performance optimization.

•Write relational and multidimensional database queries.

•Functional Knowledge of Talend Adminstration Center, Job Servers & Load balancing setup, and all its administrative fucntions.

•Develop, maintain, and enhance unit test suites to verify the accuracy of ETL processes, dimensional data, OLAP cubes and various forms of BI content including reports, dashboards, and analytical models.

•Exposure in Map Reduce components of Talend / Pentaho PDI.

•Creating and deploying Talend / Pentaho custom components is an add-on advantage.

Job Specification:

•BE, B.Tech / MS Degree in Computer Science, Engineering or a related subject.

•Having an experience of 2 – 3+ years.

•Comprehensive understanding and working knowledge in Data Warehouse loading, tuning, and maintenance.

•Proficiency with Talend or related tools like Pentaho Data Integration / Kettle.

•Working knowledge of relational database theory and dimensional database models.

•Ability to write complex SQL database queries.

•Ability to work independently.

Min. Qualification:

ug

Skills Required:

database, etl, pentaho, sql