Skills Required:-

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, talent , 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, and process automation.