Apply Now

Developer - ETL / Informatica MFT

Cary, NC, US • Posted 1 day ago • Updated 9 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

Business Data
Big Data
PL/SQL
Data Science
Use Cases
Meta-data Management
Reference Data
Data Governance
Quality Assurance
Technical Drafting
Documentation
Project Delivery
Collaboration
Computer Science
Information Technology
Data Management
Data Engineering
Data Integration
Distributed Computing
Data Modeling
Writing
Functional Requirements
High-level Design
Scripting
Extract
Transform
Load
Data Analysis
Data Profiling
Data Warehouse
SQL
Data Quality
Analytical Skill
Conflict Resolution
Problem Solving
Communication
Informatica
MFT
Insurance
Leadership
Management
Amazon Web Services
Snow Flake Schema
Cloud Computing
Agile
Software Development Methodology

Business Data
Big Data
PL/SQL
Data Science
Use Cases
Meta-data Management
Reference Data
Data Governance
Quality Assurance
Technical Drafting
Documentation
Project Delivery
Collaboration
Computer Science
Information Technology
Data Management
Data Engineering
Data Integration
Distributed Computing
Data Modeling
Writing
Functional Requirements
High-level Design
Scripting
Extract
Transform
Load
Data Analysis
Data Profiling
Data Warehouse
SQL
Data Quality
Analytical Skill
Conflict Resolution
Problem Solving
Communication
Informatica
MFT
Insurance
Leadership
Management
Amazon Web Services
Snow Flake Schema
Cloud Computing
Agile
Software Development Methodology

Summary

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.

Required Skills & Qualifications

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91134517
Position Id: 139f5370ffea81be9622bba6d7796b5f
Posted 1 day ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Integration Lead Analyst

Cary, North Carolina

•

3d ago

Face to Face interview is a must Key Responsibilities: Work with business/data product team to translate given business problem into analytical solution with defined outcomes. Analyze the data in depth, informatica MFT, using SQLs and other exploratory tools against various platforms such as Bigdata, Oracle, SQL Server and others. Convert business requirements to functional requirements, with detailed transformation rules for ETL team. This is a very technical hands-on role and mandatory to have

Easy Apply

Contract, Third Party

Depends on Experience

Sr. Data Analyst

Greensboro, North Carolina

•

Today

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility . Job Summary The mission of Arch Mortgage Data, Reporting and Insights team is to unlock the power of data through insightful reporting and analytics, empowering stakeholders to confidently make data-d

Full-time

TxDMV - Systems Analyst - Data Engineer (Remote in TX)

Remote or Texas

•

Today

Job Description State Classification Title: Systems Analyst V NOTE: This position is currently eligible for telecommuting within the state of Texas. However, this is subject to change, and the position may transition to an inoffice assignment at a designated work location within the state based on space availability and agency needs. Must attend meetings/training at headquarters in Austin, TX as required by management. Selected applicant must reside in Texas. Visa sponsorship is not available.

Full-time

USD 5,797.66 - 9,508.25 per month

Lead Data Analyst with Medicaid / Pharmacy / PBM experience

Remote

•

3d ago

We are seeking to hire a Advisor (Lead) Data Analyst with expertise in Medicare / Pharmacy Benefits Management systems, to join our teams working on a new multi-year awards we have within several State Govt clients, modernizing their Medicare/Medicaid systems. These roles are 100% remote. Being a US Cit is required for working on this program. This position pays a strong salary package with full benefits (including choice of healthcare plans, dental, vision, life insurance, 3 weeks PTO, 11 Paid

Easy Apply

Full-time

Depends on Experience

Search all similar jobs

More jobs at Hudson IT in Cary, NC