ETL Lead Developer (Pentaho/SQL Server/SSIS)

at  Travancore Consultancy(Posted by travancore consultancy)

Data Warehouse / ETL Lead Developer (Pentaho/SQL Server/SSIS)

Greeting from Zsah Managed Technology Services!

We are hiring for ETL Developer with our client based out in Bangalore Location.

Location             : Bangalore

Role                        : Data Warehouse / ETL Developer – JD

Experience           : 6+ Years

Job Type          : Permanent

Job Description:

 A highly experienced Data Warehouse Developer with proficient knowledge in ETL Design and Development using Pentaho Data Integrator and SQL Server technology stack. The candidate must have knowledge in Data Warehouse concepts, dimensional modeling and ETL architecture. Candidate should be disciplined, detail-oriented, self-motivated, and delivery-focused.

Skills Required: 

Technical skills:

·             In-depth knowledge and hands-on experience with Data Extraction, data integration, Transformation and Data Migration.

·             Experience in Data Profiling, Data conformance, Data Quality, Data Governance and Data Lineage.

·             Expert in Pentaho Data Integrator version 7.6 / 8.1 and SQL Server 2012/2014/2016

·             Designing and developing ETL processes for SQL Server based Data Warehouse.

·             Works with BI Architect and Technical Lead to understand solution vision and create data integration design.

·             Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling

·             Follows industry standards and best practices.

·             Strong knowledge in using Pentaho enterprise version and Metadata data based injection methods.

·             Plans and conducts ETL unit and development tests; monitors results and takes corrective action

·             Defines and implements data quality logic associated with data processing flows

·             Designs, develops, automates, and supports complex applications to extract, transform, and load data from multiple sources into accessible and performant structures that support analytic needs

·             Performance tuning of ETL processes

·             Providing production support

Non-Technical skills:

·             Strong Communication skills

·             Must work as a team to focus on Delivery

·             Must have experience with On Site and Off Shore Development model.

Skills Desired but not mandatory:

·             Big Data technologies – Hive, Map Reduce

·             Python 2.7 / 3.7

·             Java Script

KINDLY SEND THESE DETAILS ALONG WITH LATEST RESUME IN WORD FORMAT

• Full Name:

• Total Year of Exp.:

• Relevant Year of Exp.:

• Current company:

• Current CTC:

• Exp. CTC:

• Notice Period:

• Negotiable Notice Period/Buyout:

• Skype ID:

• Contact no:

• Reason for change:

Thank you,