Data Integration Developer

PROLIM Global Corporation
Texas Township, MI, United States
10 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours

Tech stack

Artificial Intelligence Data Analysis CA Workload Automation Ae Microsoft Azure Cloud Computing Cloud Database Databases Customer Data Management Data Integration Extract Transform Load (ETL) Database Queries Python (Programming Language)
+11 more
Microsoft SQL Server SQL Azure Oracle (Applications) Shell Script SQL Databases Teradata SQL Freeform SQL Sql Optimization Informatica Powercenter Integration Frameworks Control M

Job description

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., * 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

Requirements

Database Extract Transform and Load (ETL), Informatica, Cloud Computing, Data Quality, SQL (Structured Query Language), Data Modeling, MultiLoad, BTEQ, NCR Teradata, Microsoft Windows Azure, * 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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…