Vacancy expired!
Strong experience in ETL Development in Informatica PowerCenter Onshore Team Lead Excellent Communication skills Gathering Requirments and participate in discussions with business and IT Stake holders Drive the offsore project team and involve in calls with offshore team Expericen in Informatica PowerCenter Strong Data Analytical capabilities Design and develop SQL Server stored procedures functions views and triggers to be used during the ETL process. Design and develop ETL solutions using data integration tools for interfacing between source application and the Data Marts. 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. Troubleshoot data issues and defects to determine root cause. 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 automations. Hours : 8:00am to 5:00pm Education : Additional Job Details :
Vacancy expired!