Senior Data Integration Developer

We are looking for a Senior Data Integration Developer with strong expertise in SSIS, Informatica PowerCenter, Oracle, and Microsoft SQL Server to design, develop, and maintain enterprise-grade data integration and ETL solutions.

• Key Responsibilities:
• Design, develop, test, and maintain enterprise-grade ETL solutions using SQL Server Integration Services (SSIS) and Informatica PowerCenter.
• Build, optimize, and support data integration workflows to meet business and operational requirements.
• Design and implement scalable data warehousing solutions.
• Execute and support large-scale data migration projects while ensuring data quality, consistency, and integrity.
• Develop, optimize, and maintain Oracle PL/SQL packages, procedures, functions, and triggers.
• Develop advanced T-SQL scripts, stored procedures, and optimize performance in Microsoft SQL Server.
• Analyze business and technical requirements and recommend scalable data integration solutions.
• Troubleshoot ETL failures, resolve performance bottlenecks, and address data quality issues.
• Collaborate with business stakeholders, solution architects, database administrators, and development teams to deliver high-quality solutions.
• Adhere to coding standards, documentation best practices, and change management processes.
• Participate actively in Agile ceremonies, including sprint planning, daily stand-ups, sprint reviews, and retrospectives.

• Min 5+ Years of experience in SQL Server Integration Services (SSIS 2019) for designing, developing, and deploying ETL solutions.
• Extensive experience in Informatica PowerCenter development, including ETL workflows, mappings, and performance optimization.
• Proven expertise in enterprise ETL architecture, design, development, and optimization for large-scale data integration projects.
• Strong understanding of data warehousing concepts, including dimensional modeling, data marts, and ETL best practices.
• Hands-on experience in data migration planning, execution, validation, and reconciliation across enterprise systems.

Database Technologies

• Strong experience with Oracle Database administration and development.
• Expertise in Oracle PL/SQL programming, including packages, procedures, functions, triggers, and performance tuning.
• Extensive experience with Microsoft SQL Server development and administration.
• Advanced proficiency in T-SQL, including query optimization, indexing strategies, stored procedures, and performance tuning.