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)