Job Title: ETL Data Integration Architect
Location: Mumbai / Pune
Experience: 10 – 15 Years
Skills Required: Informatica, IICS, IDMC, Talend, Data stage, Pyspark, Qlik Replica
Job Summary
We are seeking an experienced ETL Data Integration Architect to design, develop, and optimize scalable data integration solutions across enterprise systems. The ideal candidate will bring deep expertise in modern ETL tools, cloud data integration platforms, and big data technologies, ensuring efficient and reliable data pipelines across the organization.
Key Responsibilities
- Design and architect end-to-end data integration solutions using ETL and ELT frameworks
- Lead implementation of data pipelines using tools like Informatica, IICS, IDMC, Talend, and DataStage
- Develop and optimize data ingestion, transformation, and loading processes
- Build scalable data pipelines using PySpark for big data environments
- Integrate data across multiple sources including databases, APIs, cloud platforms, and streaming systems
- Ensure data quality, governance, and integrity across all integrations
- Implement real-time and batch data replication strategies using tools such as Qlik Replicate
- Collaborate with cross-functional teams including Data Engineering, Analytics, and Business teams
- Provide technical leadership, best practices, and mentoring to junior team members
- Evaluate and recommend new tools, technologies, and frameworks for data integration
- Troubleshoot performance issues and optimize ETL workflows
Required Skills & Expertise
- Strong hands-on experience in:
- Informatica PowerCenter / IICS / IDMC
- Talend / IBM DataStage
- Experience with PySpark and distributed computing frameworks
- Expertise in data modeling, ETL design patterns, and data warehousing concepts
- Knowledge of cloud platforms (AWS, Azure, or GCP) and cloud-native data services
- Experience in Qlik Replicate or other data replication tools
- Strong SQL skills and experience with RDBMS and NoSQL databases
- Familiarity with CI/CD pipelines and DevOps practices in data engineering
Preferred Qualifications
- Experience in real-time/streaming data integration (Kafka, etc.)
- Knowledge of data governance, lineage, and catalog tools
- Exposure to modern data platforms like Snowflake, Databricks, or BigQuery
- Certifications in Informatica / Cloud platforms
Interested candidates share their resume to [Confidential Information]