We are seeking an experienced Data Integration Developer with strong hands-on expertise in Informatica PowerCenter and cloud data integration tools. The ideal candidate will have deep ETL development experience, strong SQL skills, and exposure to large enterprise data environments, with a focus on data quality, governance, and analytics.
Key Responsibilities
Design, develop, and maintain ETL solutions using Informatica PowerCenter, IDC, and IDMC/IICS
Build and manage mappings, mapplets, sessions, and workflows aligned with technical specifications
Perform data integration, transformation, and loading across multiple source systems
Develop data models and ensure data accuracy, consistency, and integrity
Implement data quality rules and governance policies
Work with Teradata utilities (BTEQ, MultiLoad, FastExport, TPT, SQL Assistant)
Write and optimize advanced SQL queries across Oracle, SQL Server, Teradata, and Azure SQL
Use Unix/Linux shell scripting for automation and scheduling
Collaborate with business and analytics teams to deliver dashboards and reports
Analyze customer data to identify trends, insights, and improvement opportunities
Ensure compliance with data regulations such as GDPR and CCPA
Required Skills & Qualifications
8-10 years of experience in Informatica PowerCenter and ETL development
Strong experience with IDMC/IICS (Cloud Data Integration)
Advanced SQL proficiency and solid understanding of data modeling
Hands-on experience with Teradata utilities
Experience working in large enterprise environments
Knowledge of Unix/Linux shell scripting and scheduling tools (Control-M, Autosys)
Strong analytical and problem-solving skills
Nice to Have
Experience with MDM and Analytics Reporting
BI/Data Modeling using Informatica or Python
Exposure to AI/ML or advanced analytics
Experience building customer analytics dashboards
Numbers & Facts
Location
Michigan, TX (Remote)
Skills
Analysis Skillsunmatched
Artificial Intelligence (AI)unmatched
BTEQunmatched
Business Intelligenceunmatched
CA Workload Automation AE (AutoSys Edition)unmatched
Cloud Computingunmatched
Customer/Client Researchunmatched
Data Analysisunmatched
Data Modelingunmatched
Data Qualityunmatched
Database Extract Transform and Load (ETL)unmatched
Informaticaunmatched
Linux Operating Systemunmatched
Maintain Complianceunmatched
Manufacturing Data Managementunmatched
Microsoft SQL Serverunmatched
Microsoft Windows Azureunmatched
MultiLoadunmatched
NCR Teradataunmatched
Oracle Databaseunmatched
Problem Solving Skillsunmatched
Python Programming/Scripting Languageunmatched
Query Optimizationunmatched
Regulatory Complianceunmatched
Reporting Dashboardsunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Trend Analysisunmatched
Unix Shell Programmingunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.