Handle multiple projects in parallel Work closely with Business Analysts and help them in FRD completion Participate and deliver Solution design, working closely with the architecture team.
Understand business requirements and convert them into detail technical specifications for Data Quality and Data Governance rules.
Extensive experience in Informatica Data Quality using profiling, score card and business glossary Experience in LDO and PDO is mandatory Design and Develop Review.
ETL programs primarily using Informatica PowerCenter, PLSQL, Unix Shell Scripts Participate in the new team member hiring process Coach and guide the technical team in terms development of Data Quality jobs Performance improvement tuning of Informatica mappings, SQL PLSQL scripts Technical reviews, Data validation end to end testing of ETL Objects, Source data analysis and data profiling.
Create necessary documentation as per SDLC standards Update the project documentation (Change Requests and JIRArsquos) on the confluence Support QE on End-to-End testing and provide dailyweekly project status to the Project manage.
Work with deployment team in the code migration across the SDLC environments Triage the Production issues and work on the code fixes. Experience with Informatica installation and configuration Administration and Security setup 4+ years of experience in implementation of Data Quality projects in a large scale enterprise data warehouse environment Dimensional Modeling and Data warehouse concepts, such as star schemas, snowflakes, dimensions, facts etc.
Should have hands on experience in designing large scale Enterprise Data Warehouse environments Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, etc Hands on experience with database like Oracle, MSSQL Server and database languages like SQL, PLSQL and T-SQL Strong SQL, PLSQL tuning Informatica performance improvement