We are looking for a highly skilled Senior ETL Developer with expertise in Informatica and a strong understanding of data integration, data warehousing, and ETL processes. The ideal candidate should have at least 8 years of development experience, including significant experience in the financial domain particularly in Wealth Management. This role involves hands-on development of complex ETL processes using Informatica PowerCenter and creating reports on Jasper.
Responsibilities
· Design, develop, and implement ETL processes using Informatica PowerCenter to extract, transform, and load data from various sources into target systems (databases, data warehouses, etc.).
· Work with large datasets and complex data structures to integrate and transform data from multiple sources.
· Create and maintain technical documentation, including data flow diagrams, ETL mappings, and process flow charts.
· Troubleshoot, optimize, and enhance ETL workflows for performance, scalability, and reliability.
· Project Management: Create, assign, and track project work plans for timely delivery while ensuring adherence to defined quality standards.
· Technical Guidance: Provide technical guidance to team members to enhance their technical capabilities and productivity.
· Process Improvement: Design and implement data validation and quality checks to ensure data accuracy and consistency across different systems. Ensure process improvement and compliance in the assigned module and participate in technical discussions or reviews.
· Status Reporting: Prepare and submit status reports to minimize exposure and risks on the project and manage escalations effectively.
· Collaboration: Collaborate with business analysts, architects, and stakeholders to understand business requirements and translate them into efficient ETL solutions.
Essential Requirements (Skills Requirements)
· Education: Bachelor's degree in Computer science or a related field.
· Years of Experience: Minimum 8 years of development experience.
· Strong understanding of data integration, data warehousing, and ETL processes
· Domain Experience: Minimum 3 years of experience in the financial/ wealth banking domain, specifically in commercial banking with exposure to payments processing and technologies across the payment lifecycle.
Good to Have
· Additional Skills: Exposure to cloud platforms such as AWS, Azure, or GCP for data integration and ETL operations
· Experience with Agile Methodologies: Familiarity with Agile development practices and tools like JIRA or Trello.
Technical / Professional Skills
· Proficiency in Informatica PowerCenter, Informatica Power exchange, Data modelling, Snowflake DB, Oracle, SQL Server, MySQL, PostgreSQL, Teradata, Python, Linux, Jasper, GIT.
· Strong hands-on experience with Informatica and other utilities like Informatica Power exchange.
· Strong understanding of data integration, data warehousing, and ETL processes
· Experience with performance tuning and optimization of ETL workflows and real time loading of data from MQ.
· Strong analytical skills and the ability to troubleshoot and resolve complex data integration issues.
· Proficiency in working with relational databases (e.g., Oracle, SQL Server, MySQL, PostgreSQL) and SQL for complex queries and transformations.
· Solid experience with data modeling and database design.
· Hands on experience in creating complex reporting using Jasper Studio
· Experience with version control systems (e.g., Git) and CI/CD pipelines
Non-Technical / Soft Skills
· Communication: Excellent communication skills to effectively collaborate with cross-functional teams and stakeholders.
· Team Player: Strong team player with the ability to mentor and guide junior developers.
· Problem-Solving: Strong problem-solving skills to identify and address issues in code, optimize user experiences, and troubleshoot technical challenges.
· Leadership: Ability to lead technical discussions and provide guidance to the development team.
Informatica PowerCenter, Informatica Power exchange, Data modelling, Snowflake DB, Oracle, SQL Server, MySQL, PostgreSQL, Teradata, Python, Linux, Jasper, GIT
Financial/Wealth Banking Domain work Experience