ETL Informatica Developer

Diverse Lynx; Remote; USD 100,000 - 125,000; Full time

Job summary

A leading consulting firm is seeking an ETL Informatica Developer. This remote role requires 8 to 10 years of experience in Informatica Power Center and strong SQL skills. The successful candidate will implement data quality rules, manage customer data lifecycles, and develop actionable dashboards. Ideal applicants should have hands-on experience with data modeling and analytics. Join a diverse workforce committed to excellence in data integration and customer insights.

Qualifications

• 8 to 10 years' experience in Informatica Power Center and related technologies.
• Strong SQL proficiency (Oracle, SQL Server, Teradata, etc.).
• Hands-on Informatica development and ETL consulting experience preferred.
• Knowledge of Unix/Linux shell scripting and scheduling tools is a plus.

Responsibilities

• Implement data quality rules and governance policies.
• Manage the lifecycle of customer data for compliance.
• Analyze customer data for trends and insights.
• Develop dashboards and reports for stakeholders.

Skills

ETL

Informatica

Data Module

Data Integration

SQL

Java

Data Modeling

Shell Scripting

BI Data Modeling

Job description

Job Overview

Job Title: ETL Informatica Developer

Location: Remote

Position: C2C Role

Duration: 6+ Months

Pay Range: $50 – 57/Hr

Skills: ETL, Informatica, Data Module, Data Integration.

Job Description

1. 8 to 10 years' experience in Informatica Power Center, IDC, PowerShell, Informatica Packages such as IDMC/IICS.
2. Hands on Informatica development experience and should have ETL consulting experience is preference. Preferrable with MDM and Analytics reporting.
3. Hands on experience with Data Module & Framework Manager development with power Center.
4. Should have Strong SQL proficiency (Oracle, SQL Server, Teradata, etc.) and understanding of data modeling.
5. Should hold strong expertise in Teradata utilities like BTEQ, Multi-Load, view point, SQL assistant, Azure SQL Databases and Fast Export, TPT.
6. Experience with Large Enterprise Clients and Knowledge of Unix/Linux shell scripting for automation and experience with scheduling tools (e.g., Control-M, Autosys).
7. Advanced knowledge of SQL and Java. Should have strong experience in create mapping, mapplets, sessions, and workflows, ensuring alignment with technical specifications.
8. BI Data Modeling – Informatica or Python and should have ability to analyze complex data sets and ensure data quality/integrity.
9. Implement data quality rules and governance policies to ensure the accuracy, consistency, and completeness of customer data across the enterprise.
10. Manage the lifecycle of customer data, ensuring compliance with relevant regulations (e.g., GDPR, CCPA).
11. Analyze customer data to identify trends, patterns, and insights that can inform customer experience initiatives.
12. Develop and maintain dashboards and reports that provide clear and actionable insights to stakeholders.
13. Utilize advanced analytics tools and techniques (including potentially AI/ML) to segment customers, predict future behavior, and identify opportunities for improvement is an added advantage.

Equal Employment Opportunity Statement

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.