Informatica Developer

Skills Required

• Informatica
• RDBMS (Oracle / DB2)
• Unix/Linux
• Control-M
• GitLab
• Experience in Insurance domain and Guidewire ClaimCenter

Key Responsibilities

• Analyze business requirements and design, develop, and implement scalable ETL processes
• Understand data warehouse and data migration concepts
• Develop ETL specifications based on business needs
• Design technical solutions for data integration
• Work with source system teams to define data extraction methods
• Develop and optimize complex SQL and PL/SQL queries
• Re-architect existing ETL components for better performance and scalability
• Deploy ETL workflows using Control-M
• Configure GitLab pipelines for deployment
• Perform coding, testing, debugging and documentation of ETL processes
• Maintain software quality through SDLC best practices
• Support Unit Testing, Integration Testing and UAT
• Participate in automation and process improvements
• Convert issues into JIRA tasks and support resolution
• Manage multiple priorities in a fast-paced environment

Technical Requirements

Informatica

• Hands-on experience with Informatica 10.x and above
• Strong knowledge of ETL design and development
• Experience in data analysis and data quality checks

Ratabase Skills

• Strong experience with Oracle / DB2
• Expertise in complex SQL and query optimization
• Knowledge of data warehousing concepts

Unix/Linux

• Proficient in shell scripting