AIA Project Manager

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 :