Developer – ETL / Informatica MFT
Description
Job Description
We are looking for a highly technical Developer / Data Analyst with strong experience in ETL, 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 using SQL, Informatica MFT , and other exploratory tools across platforms such as Big 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 using Informatica 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 using MFT 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 maintain metadata, 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.