Job Details
The DQ Consultant has overall IT experience of 8-12 years in the capacity of DQ Analyst/ ETL Senior Developer/ ETL lead, implementation and technical responsibilities Very strong implementation experience in Data Integration tools specialized with Informatica Power Center and IDQ suite or other DQ tools Experience delivering scalable Enterprise DQ solutions with workflows handling initial, delta data loads with CDC Good Knowledge of ETL and Data Quality Concepts, knowledge of basic concepts of Java, Rest API calls, JSON and XMLs Must have experience on data process and transform Ability to predict, quantify technical risks and manage it in the project Experience in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling Designing, developing, testing, deploying, and documenting a data quality procedure and its outputs Profile the source data, define or confirm the definition of the metadata, cleanse and accurately check the data, check for duplicate or redundant records, and provide information on how to proceed with backend ETL processes Developing good relationships with users across the firm and interacting with them to resolve any data quality issues (use cases).
Experiences with creating SQL procedures, views, subqueries, multiple SQL joins, unions to perform various data extraction tasks and developing PL/SQL triggers for updating or inserting new records Minimum 4-6 years of hands-on experience with Data Quality toolsets Assist other departments in the design of quality edit checks, test plans, etc Assist other departments in the design of quality edit checks, test plans, etc to ensure data quality objectives are met, as well as participate in cross-functional teams and development/improvement task forces Strong SQL skills with the ability to tune and optimize complex queries Experience in Tableau will be added advantage