Must Have Technical/Functional Skills
Primary Skill: SQL ,PL/SQL
Secondary: Informatica
Experience: Minimum 10 years
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