Developer – ETL / Informatica MFT

Job Description

We are looking for a highly technicalDeveloper / Data Analyst with strong experience inETL, Informatica MFT, DBT, Snowflake, SQL, and data analysis. The candidate will work closely with business, data product, ETL, and data science teams to translate business problems into technical and analytical solutions.

Location: Cary, NC
Interview: Face-to-Face Interview – Local Candidates Only
Duration: 6–12+ Months Contract

Key Responsibilities

• Work with business and data product teams to translate business problems into analytical solutions with clearly defined outcomes.

• Perform in-depth data analysis usingSQL, Informatica MFT, and other exploratory tools across platforms such asBig Data, Oracle, SQL Server, and other data environments.

• Translate business requirements into detailed functional requirements and transformation rules for ETL teams.

• Develop and support data integrations usingInformatica MFT, DBT, and Snowflake.

• Work closely with ETL and data science teams to review requirements, data integrations, and transformation processes.

• Understand business and data science requirements and assess their impact on business use cases.

• Develop validation scripts to validate data loaded by ETL teams and assess data usingMFT and DBT.

• Collaborate with IT and business stakeholders to define and design requirements and formulate technical designs.

• Gather and document functional requirements based on business domain knowledge.

• Capture and maintainmetadata, data lineage, reference data management, and data quality rules as part of data governance.

• Perform data profiling, anomaly detection, and quality analysis across various datasets.

• Develop functional requirements and high-level technical/design documentation.

• Work with globally distributed teams to drive project delivery and ensure successful implementation.

• Collaborate with senior IT and business stakeholders to identify, raise, and track defects through project completion.

• Participate in Agile development processes and follow established SDLC methodologies.

Required Skills & Qualifications

• Bachelor’s degree inComputer Science, Engineering, Information Technology, or a related discipline.

• 8+ years of experience in Solutions Development, Data Analysis, or a related technical discipline.

• 5+ years of experience working within Data Management / Data Engineering organizations.

• Strong hands-on experience withInformatica MFT and related scripting/data integration technologies.

• Mandatory experience withInformatica MFT, DBT, and Snowflake.

• Strong understanding ofdistributed computing principles.

• Extensive experience indata analysis and data modeling, including table design.

• Strong proficiency inSQL and data exploration tools.

• Experience writing detailedfunctional requirements, transformation rules, and high-level design documents.

• Hands-on experience developing validation scripts fordata, data integrations, and ETL transformations.

• Strong data analysis, data profiling, and data quality assurance skills.

• Strong understanding ofdata warehouse concepts.

• Experience working with structured and unstructured datasets.

• Strong SQL skills fordata anomaly detection and data quality validation.

• Excellent analytical and problem-solving skills.

• Excellent written and verbal communication skills.

Preferred Skills

• Strong experience withInformatica MFT and DBT.

• Working knowledge ofcloud technologies, preferably AWS.

• Strong hands-on experience withSnowflake.

• Experience in theInsurance industry, preferably in a Lead Analyst or senior technical role.

• Experience interacting withsenior IT and business leadership.

• Experience raising, managing, and tracking defects through project completion.

• Knowledge ofAWS, Snowflake, and cloud-based data environments.

• Strong understanding ofAgile methodologies and SDLC processes.

• Experience with manual and automated design/validation processes.