ETL Developer (Informatica + SQL)

Synechron; Mumbai; On-site; INR 700,000 - 1,300,000; Full time

Job summary

Synechron is seeking a skilled ETL Developer to design, build, and maintain ETL workflows. You will extract, transform, and load data from multiple sources into data warehouses, using Informatica PowerCenter and SQL to ensure data quality and performance.

You will collaborate with analysts and business stakeholders, document data mappings, and troubleshoot data processing issues to minimize operational impact.

Qualifications

• Proficient in ETL design and development using Informatica PowerCenter.
• Strong SQL skills for data manipulation, querying, and optimization.
• Experience with data quality checks and validation processes.

Responsibilities

• Design, develop, and implement ETL workflows from multiple sources into data warehousing solutions.
• Utilize SQL for data manipulation and optimization in relational databases (Oracle, SQL Server, MySQL).
• Implement data quality checks to ensure data integrity and accuracy.
• Analyze and optimize ETL processes and SQL queries for performance improvements.
• Collaborate with data analysts, stakeholders, and IT teams to meet business needs.
• Maintain documentation of ETL processes, mappings, and technical specs.
• Identify and resolve data processing issues with minimal impact to operations.

Skills

ETL Development

SQL & Databases

Informatica PowerCenter

Data Quality

Tools

Informatica PowerCenter

Oracle

SQL Server

Job description

Key Responsibilities

• ETL Development: Design, develop, and implement ETL workflows using Informatica PowerCenter to extract, transform, and load data from multiple sources into data warehousing solutions.
• Database Management: Utilize SQL for data manipulation, querying, and optimization in relational database systems (e.g., Oracle, SQL Server, MySQL).
• Data Quality Assurance: Implement data quality checks and validation processes to ensure the integrity and accuracy of data.
• Performance Tuning: Analyze and optimize ETL processes and SQL queries for improved performance and reduced processing time.
• Collaboration: Work closely with data analysts, business stakeholders, and other IT teams to gather requirements and ensure ETL solutions meet business needs.
• Documentation: Maintain detailed documentation of ETL processes, data mapping documents, and technical specifications.
• Support and Troubleshooting: Identify and resolve any data processing issues, ensuring minimal impact on data operations and reporting.