We are looking for a candidate with experience Informatica’s CDQ module, Databricks, Microsoft Azure Data Factory, and Python coding.

Essential Duties and Responsibilities

• Experienced in Configuration, and Administration of Informatica Data Quality and Informatica Data Analyst.
• Expertise in address data cleansing using Informatica Address Doctor to find deliverable personal and business addresses.
• Analyzed Data Profiling Results and Performed Various Transformations.
• Hands on Creating Reference Table using Informatica Analyst tool as well as Informatica Developer tool.
• Experienced in Data Cleansing, Validation and Audit.
• Expertise using Address Validator, Parser, Key Generator, Match Standardizer, Expression transformation.
• Experience in creating PDO, CDO and LDO to import data (flat file, relational database file etc.)
• Experience in using Standardizer transformation to standardize the data.
• Expertise in using varied Transformation logic like Filter, Expression, Unconnected and Connected lookups, Aggregator, Joiner, Update Strategy, Data Transformation Services, Sorter etc. for designing and developing complex mappings.
• Experienced in using various log files for troubleshooting techniques and error handling.
• Excellent Knowledge on developing and debugging Mapplets, Workflow and Mappings.
• Expertise in SQL scripts and stored procedure to perform various business transformations as well as validations on data.
• Experience working with Dimensional data models, Star schema models, Snow - Flake models, identification of fact and dimension tables, Normalization, Physical and Logical Data Models.
• Excellent knowledge of developing transformation pipelines using Azure Data Factory (ADF) is a must.
• Experience working with Python coding.
• Working knowledge of using open-source data quality models.
• Expertise in agile methodologies of Software Development Life Cycle (SDLC).
• Excellent Communication, Organizational & Analytical Skills.
• Good Team Player, Fast Learner and Highly Motivated.

Position Requirements

• Bachelor’s degree in computer science, Information Systems, or related field.
• About 5+ years of experience in IT industry working with tools Informatica Data Quality, Informatica Data Analyst and Informatica Power Center, Azure Data Factory, Python.
• Strong proficiency in SQL querying, stored procedures, and database design concepts.
• Familiarity with data warehousing concepts, dimensional modeling, and data mart design.
• Excellent problem-solving skills and attention to detail with the ability to analyze complex data and business requirements.
• Strong communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams.