Senior Software Engineer (Informatica) (JD25870A)

Responsibilities

• Design, develop, and implement integration solutions for applications migrating to the AWS Cloud platform.
• Design and develop ETL processes to extract data from various sources (e.g., databases, flat files, APIs), transform as per business requirements and load it in to data warehouse or other data storage systems.
• Integrate data from multiple heterogeneous sources and ensure it is transformed and loaded correctly into the target system, maintaining data quality and integrity.
• Write complex SQL queries and use transform logic to clean, aggregate, and transform data as per business requirements.
• Ensure ETL processes are optimized for performance, scalability and reliability.
• Implement data validation rules and perform data quality checks to ensure accuracy and completeness of data.
• Troubleshooting and resolve issues related to data integration, loading failures, and performance bottlenecks...