Requirements
Bachelor's degree in Computer Science, Information Systems, or related field. Minimum 5+ years of hands-on experience with ETL tools and database systems. Strong background in database management systems (Oracle, SQL Server, Sybase, etc.). Advanced SQL skills (complex queries, joins, optimization, stored procedures, triggers, views). 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).
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.ResponsibilitiesDesign, 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).QualificationsBachelor'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 haveUnderstanding of data security, governance, and compliance practicesExperience in Agile/Scrum environmentsBanking or financial services domain knowledgeBasic knowledge of programming languages (Java, C#, .NET)