Informatica Developer

Hadiamondstar Software Solutions LLC

McLean (VA)

On-site

USD 90,000 - 130,000

Full time

2 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Hadiamondstar Software Solutions LLC is seeking an experienced ETL/ELT Engineer to develop and maintain data pipelines using Informatica IICS and Snowflake. You will write complex SQL, implement source-to-target mappings, and validate data across warehouses in an Agile/Scrum environment.

Responsibilities include ETL testing, data validation, troubleshooting, and documenting transformation logic and data flows to support business decisions.

Qualifications

Experience writing complex and optimized SQL queries, joins, CTEs, stored procedures, and transformations.
Analyze source data and create effective source-to-target mappings.
Perform ETL testing, data validation, reconciliation, and troubleshooting.

Responsibilities

Develop and maintain ETL/ELT pipelines using Informatica IICS.
Design and implement data loading and transformation processes in Snowflake.
Collaborate with business, data, and development teams in an Agile/Scrum environment.
Document mappings, transformation logic, ETL processes, and technical solutions.
Identify and resolve data-quality and pipeline issues.

Skills

Informatica IICS

Snowflake

SQL

ETL/ELT pipelines

Dimensional data models

Data validation

Agile/Scrum

Tools

Informatica IICS

Snowflake

Job description

Develop and maintain ETL/ELT pipelines using Informatica IICS.
Design and implement data loading and transformation processes in Snowflake.
Write complex and optimized SQL queries, joins, CTEs, stored procedures, and transformations.
Analyze source data and create effective source-to-target mappings.
Perform ETL testing, data validation, reconciliation, and troubleshooting.
Work with data warehouses and dimensional data models.
Identify and resolve data-quality and pipeline issues.
Collaborate with business, data, and development teams in an Agile/Scrum environment.
Document mappings, transformation logic, ETL processes, and technical solutions.