Roles & Responsibilities:
We are seeking an experienced SQL Developer with Informatica expertise to design, develop, and support enterprise data integration and data warehousing solutions.
The ideal candidate should have strong hands-on experience in SQL development, ETL processes, data modeling, and Informatica PowerCenter/IDMC within a large-scale enterprise environment.
Key Responsibilities:
- Design, develop, test, and maintain complex SQL queries, stored procedures, functions, views, and database objects.
- Develop and support ETL workflows using Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC).
- Analyze business requirements and translate them into technical data solutions.
- Perform data extraction, transformation, and loading (ETL) activities from multiple source systems.
- Optimize database performance through query tuning and indexing strategies.
- Troubleshoot ETL failures, data quality issues, and performance bottlenecks.
- Collaborate with business analysts, data architects, and application teams to deliver data integration solutions.
- Implement data validation, reconciliation, and quality checks.
- Support production deployments and resolve production incidents.
- Create and maintain technical design documentation and operational runbooks.
- Participate in data migration, modernization, and cloud transformation initiatives.
- CI/CD deployments
- Experience in Git/Bitbucket