Netlink Software - ETL Developer - Talend/Informatica (3-5 yrs)

Job Description :

- Experience in data modelling, database design, optimization techniques

- Develop, design, tune and maintain ETL routine to perform the ETL process.

- Hands on experience on ETL tools like Pentaho, Informatica, talend , etc

- Knowledge of Vertica, Teradata, Oracle, SQL etc

- Design and develop MYSQL stored procedures, functions, views, and triggers to be used

during the ETL process.

- Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.

- Documents ETL data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance.

- Integrates ETL development with existing projects to maximize object reuse.

- Creates executes, and documents unit test plans for ETL and data integration processes and programs.

- Work with the data analysis team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake.

- Perform problem assessment, resolution, and documentation in existing ETL packages, mapping, and workflows in production.

- Performance tuning of the ETL process and SQL queries and recommend and implement ETL and query tuning techniques.

- Develop and create transformation queries, views, and stored procedures for ETL processes