Job Summary
We are seeking an experienced
Informatica Intelligent Cloud Services (IICS) Developer with hands-on expertise in
Databricks to design, develop, and support cloud-based data integration and ETL solutions. The ideal candidate should have strong experience in building scalable data pipelines, integrating multiple cloud and on-premises data sources, and working with modern cloud data platforms.
Key Responsibilities
- Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS).
- Build and optimize data integration workflows using Cloud Data Integration (CDI), Mass Ingestion, and Cloud Data Integration services.
- Develop and support scalable data pipelines using Databricks (PySpark & Spark SQL).
- Integrate data from cloud and on-premises sources including Oracle, SQL Server, Snowflake, Azure Data Lake, AWS S3, Google Cloud Storage, PostgreSQL, MySQL, and REST/SOAP APIs.
- Perform data extraction, transformation, cleansing, validation, and loading (ETL/ELT).
- Develop reusable mappings, parameterized mappings, taskflows, mapping templates, and workflow automation.
- Optimize ETL jobs for performance, scalability, reliability, and maintainability.
- Collaborate with business analysts, data engineers, architects, and stakeholders to understand business requirements and deliver high-quality solutions.
- Monitor production jobs, troubleshoot failures, perform root cause analysis, and implement preventive measures.
- Participate in code reviews, unit testing, deployment, release management, and production support.
- Prepare technical documentation and facilitate knowledge transfer sessions.
- Follow ETL development standards, data governance, and best practices.
Mandatory Skills
- 5+ years of experience in ETL/Data Integration development.
- 3+ years of hands-on experience with Informatica Intelligent Cloud Services (IICS).
- Strong expertise in:
- IICS Cloud Data Integration (CDI)
- Mapping Designer
- Taskflows
- Dynamic Mapping
- Parameter Files
- Reusable Mappings
- Scheduling & Monitoring
- REST & SOAP API Integration
- Error Handling and Logging
- Hands-on experience with Databricks.
- Strong knowledge of PySpark and Spark SQL.
- Experience working with Delta Lake.
- Strong SQL programming and query optimization skills.
- Experience with cloud storage platforms:
- Azure Data Lake Storage (ADLS)
- AWS S3
- Google Cloud Storage (GCS)
- Experience working with relational databases such as:
- Oracle
- SQL Server
- PostgreSQL
- MySQL
- Good understanding of ETL best practices, performance tuning, data quality, and metadata management.
- Experience in production support, incident management, and troubleshooting.
Preferred Skills
- Experience with Snowflake integration.
- Knowledge of Azure Data Factory (ADF) or other cloud ETL tools.
- Familiarity with CI/CD pipelines and Git version control.
- Experience working in Agile/Scrum environments.
- Exposure to cloud platforms such as Azure, AWS, or Google Cloud Platform (GCP).
- Knowledge of data warehousing concepts and dimensional modeling.
- Familiarity with Informatica Mass Ingestion and Cloud Application Integration (CAI) is an added advantage.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Informatica IICS Certification is a plus.
Nice to Have
- Experience with Delta Live Tables (DLT).
- Exposure to Unity Catalog.
- Experience with Apache Spark optimization techniques.
- Understanding of Data Lakehouse architecture.
- Knowledge of DevOps tools such as Azure DevOps, Jenkins, or GitHub Actions.
Skills: iics,databrics,cdi,azure
