Data Integration Developer

PROLIM Global Corporation

Plano, TX

JOB DETAILS
SKILLS
Analysis Skills, BTEQ, CA Workload Automation AE (AutoSys Edition), Cloud Computing, Customer/Client Research, Data Analysis, Data Modeling, Data Quality, Database Extract Transform and Load (ETL), Identity Data Management, Informatica, Linux Operating System, Maintain Compliance, Master Data Management (MDM), Microsoft SQL Server, Microsoft Windows Azure, MultiLoad, NCR Teradata, Oracle Database, Problem Solving Skills, Python Programming/Scripting Language, Query Optimization, Regulatory Compliance, Reporting Dashboards, SQL (Structured Query Language), Scripting (Scripting Languages), Trend Analysis, Unix Shell Programming
LOCATION
Plano, TX
POSTED
30+ days ago

Job Title Data Integration Developer

Location Remote US

Duration 6 Months 02/15/2026 - 08/15/2026

Experience 8-10 Years

Domain Data Integration ETL

Job Summary 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 IDM CIICS. 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 IDM CIICS 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 • Data Modeling using Informatica or Python • Exposure to AIML or advanced analytics • Experience building customer analytics dashboards

About the Company

P

PROLIM Global Corporation