Logo
Lutheran Metropolitan Ministr

CDQ Developer

Lutheran Metropolitan Ministr, Miami, Florida, us, 33222


Miami, United States

| Posted on 10/11/2024Data Management & Analytics Consulting firmJob Description

Position Summary

We are looking for a skilled Data Engineer who will be responsible for designing, developing, and maintaining data quality solutions. The ideal candidate will have a strong background in Informatica’s CDQ module, 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.Requirements

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.

#J-18808-Ljbffr