Developer - ETL / Informatica MFT

Hudson
Cary, NC, United States
9 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$93,600.0 - $104,000.0
Working hours
Regular working hours

Tech stack

Agile Methodology Amazon Web Services Data Analysis Big Data Cloud Computing Cloud Database Data Auditing Information Engineering Data Governance Data Infrastructure Data Integration Extract Transform Load (ETL)
+17 more
Data Profiling Data Warehousing Database Queries Distributed Systems High-Level Architecture Metadata Microsoft SQL Server Oracle (Applications) Systems Development Life Cycle Reference Data SQL Databases Unstructured Data Scripting Snowflake Information Technology Data Lineage Data Management

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., 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., Akkodis is seeking a Developer for a Contract with a client in Cary, NC. You will drive the translation of complex business requirements into scalable data solutions while ensuring…

  • 7 hours ago

Requirements

Bachelor’s degree in Computer 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 with Informatica MFT and related scripting/data integration technologies. Mandatory experience with Informatica MFT, DBT, and Snowflake. Strong understanding of distributed computing principles. Extensive experience in data analysis and data modeling, including table design. Strong proficiency in SQL and data exploration tools. Experience writing detailed functional requirements, transformation rules, and high-level design documents. Hands-on experience developing validation scripts for data, data integrations, and ETL transformations. Strong data analysis, data profiling, and data quality assurance skills. Strong understanding of data warehouse concepts. Experience working with structured and unstructured datasets. Strong SQL skills for data anomaly detection and data quality validation. Excellent analytical and problem-solving skills. Excellent written and verbal communication skills. Preferred Skills Strong experience with Informatica MFT and DBT. Working knowledge of cloud technologies, preferably AWS. Strong hands-on experience with Snowflake. Experience in the Insurance industry, preferably in a Lead Analyst or senior technical role. Experience interacting with senior IT and business leadership. Experience raising, managing, and tracking defects through project completion. Knowledge of AWS, Snowflake, and cloud-based data environments. Strong understanding of Agile methodologies and SDLC processes. Experience with manual and automated design/validation processes.

Benefits & conditions

Pay Rate Range: $ 46.96 - 50.75/hr. Job Description: Key Responsibilities: Work with business/data product team to translate given business problem into analytical solution w…

  • 1 day ago +

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

2:08 min

Creating standard APIs via the Egeria open metadata project

Ferd Scheepers · World Congress 2022

1:33 min

Integrating internal APIs and maintaining data sovereignty

Mahran Meißner Mahran Meißner · World Congress 2026 Europe

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

2:57 min

Core technical practices for robust data engineering

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

Videos

See all

Related articles

See all