Senior ETL Developer

We are looking for a highly skilled Senior ETL Developer with strong expertise in Informatica and other ETL tools. The ideal candidate will have a proven track record in managing large-scale data integration projects, optimizing workflows, and ensuring data quality across diverse platforms. This role requires advanced SQL proficiency, hands-on experience with cloud-based ETL solutions, and the ability to work with high-volume datasets in complex enterprise environments.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica (PowerCenter, IICS, Cloud) and other tools (SSIS).
• Manage and optimize database systems including Oracle, SQL Server, Sybase, etc.
• Write and tune advanced SQL queries, stored procedures, triggers, and views.
• Perform data integration, migration, and transformation across multiple systems.
• Implement data cleansing, validation, and quality assurance techniques.
• Conduct performance tuning and optimization of ETL workflows and SQL queries.
• Handle large datasets and high-volume batch processing.
• Configure and manage scheduling tools (Control-M, Autosys, cron).
• Develop automation scripts using Python, Shell, or JavaScript.
• Integrate data via APIs (REST and SOAP).
• Maintain metadata management and data lineage documentation.
• Implement error handling, logging, and monitoring for ETL jobs.
• Collaborate using version control systems (Git, SVN).
• Work with cloud-based ETL platforms (AWS Glue, Azure Data Factory).

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field
• Minimum 5+ years of hands-on experience with ETL tools and database system
• Strong background in database management systems (Oracle, SQL Server, Sybase, etc.)
• Advanced SQL skills (complex queries, joins, optimization, stored procedures, triggers, view
• Experience in data integration, migration, and transformation
• Experience in performance tuning and optimization of ETL workflows and SQL queries
• Ability to work with large datasets and high-volume data processing
• Understanding of batch processing and scheduling tools (e.g., Control-M, Autosys, cron)
• Familiarity with scripting languages (Python, Shell, or JavaScript)
• Knowledge of API integration (REST and SOAP)
• Understanding of metadata management and data lineage
• Experience in error handling, logging, and monitoring ETL jobs
• Knowledge of version control systems (e.g., Git, SVN)
• Exposure to cloud-based ETL and data platforms (e.g., AWS Glue, Azure Data Factory)

Nice to have

• Understanding of data security, governance, and compliance practices
• Experience in Agile/Scrum environments
• Banking or financial services domain knowledge
• Basic knowledge of programming languages (Java, C#, .NET)