Summary
✨ AI‑Generated
A senior data engineering role focused on designing and optimizing ETL workflows, managing enterprise databases, improving data quality, and delivering scalable data integration solutions using modern tools and cloud technologies.
Highlights
Opportunity to work on large-scale data integration initiatives with complex enterprise environments, advanced technologies, and a strong focus on data quality and performance optimization.
Description
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 fieldMinimum 5+ years of hands-on experience with ETL tools and database systemStrong background in database management systems (Oracle, SQL Server, Sybase, etc.)Advanced SQL skills (complex queries, joins, optimization, stored procedures, triggers, viewExperience in data integration, migration, and transformationExperience in performance tuning and optimization of ETL workflows and SQL queriesAbility to work with large datasets and high-volume data processingUnderstanding 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 lineageExperience in error handling, logging, and monitoring ETL jobsKnowledge 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 practicesExperience in Agile/Scrum environmentsBanking or financial services domain knowledgeBasic knowledge of programming languages (Java, C#, .NET)
