ETL Developer with Data Integration - Schaumburg, Illinois, (Locals only)

[Bharath Pammi]

ETL Developer with Data Integration

Schaumburg, Illinois, (Locals only)

13 to 15 years of experience

Long term Contract

Key Responsibilities
Data Integration & ETL Development
Design, develop, and maintain ETL/ELT pipelines using Informatica Cloud Data Integration (CDI)
Build reusable mappings, mapplets, taskflows, and workflows
Extract data from multiple sources (databases, APIs, flat files, cloud apps) and load into target systems (Data Warehouse, Data Lake, etc.)
Optimize performance of ETL jobs for large-scale data processing
Cloud & Platform Management
Work with Informatica Intelligent Data Management Cloud (IDMC) modules:
Cloud Data Integration (CDI)
Cloud Data Quality (CDQ)
Cloud Application Integration (CAI)
API Manager / Data Governance tools (optional)
Configure Secure Agent setup, connectivity, and runtime environments
Manage deployments across environments (Dev, QA, Prod)
Data Quality & Governance
Implement data quality rules, profiling, cleansing, and validation using CDQ
Ensure data consistency, completeness, and accuracy across systems
Support data governance initiatives (metadata, lineage, catalog)
Integration & APIs
Develop integrations between systems using REST/SOAP APIs
Work with third-party applications (Salesforce, SAP, Oracle, etc.)
Handle real-time and batch integrations
Collaboration & Stakeholder Management
Gather and analyze business/data requirements
Translate requirements into technical solutions
Collaborate with analysts, architects, and business users
Monitoring & Support
Monitor job executions and troubleshoot failures
Perform root cause analysis and implement fixes
Provide production support and performance tuning
Required Skills & Qualifications
Technical Skills
Strong experience with Informatica IDMC / IICS

Hands-on with:
Cloud Data Integration (CDI)
Taskflows & mappings
Secure Agent configuration
Solid understanding of:
ETL concepts and data warehousing
SQL (advanced level)
Data modeling concepts
Experience with cloud platforms:
AWS / Azure / GCP (at least one)
Knowledge of APIs (REST/SOAP), JSON, XML
Data Skills
Data transformation, cleansing, and validation
Data profiling and quality tools
Handling structured and semi-structured data

Preferred Skills
Experience with Informatica Cloud Data Quality (CDQ)
Knowledge of Informatica Data Governance / EDC / Axon
Experience in real-time integration (CAI)
Familiarity with DevOps practices (CI/CD pipelines)
Scripting knowledge (Python / Shell)
Experience with Snowflake, Redshift, BigQuery, etc.

Sripada Amarthya (Amarthya) Technical Recruiter amart...@avanceservices.us