Key Responsibilities:
- Lead the design, development, and maintenance of enterprise applications and ETL solutions.
- Design, develop, and optimize ETL workflows using Informatica and SSIS.
- Develop and maintain SQL Server and Oracle databases, including stored procedures, functions, views, triggers, and complex SQL queries.
- Perform database performance tuning, query optimization, and data migration activities.
- Design and develop reports and dashboards using SSRS and Power BI.
- Support and maintain CI/CD pipelines using DevOps tools such as Jenkins, Bitbucket, Artifactory, SonarQube, and Veracode.
- Collaborate with business stakeholders to analyze requirements and deliver technical solutions.
- Perform application integration, testing, deployment, and production support.
- Ensure adherence to software development lifecycle (SDLC) processes and coding standards.
- Provide technical guidance and mentor junior developers.
Required Technical Skills:
- ETL Tools: Informatica, SSIS
- Databases: Microsoft SQL Server, Oracle, IBM DB2
- SQL Programming: T-SQL, Stored Procedures, Views, Functions, Triggers, Query Optimization
- Reporting & BI: SSRS, Power BI, SSAS
- DevOps & CI/CD: Jenkins, Bitbucket, Artifactory, SonarQube, Veracode
- Programming: C#, ASP.NET, VB.NET, Groovy
- Web Technologies: WCF, Web Services
- Data Migration and Performance Tuning
- SDLC, Application Support, Integration Testing, Regression Testing
Preferred Experience
- Experience in Banking and Financial Services projects.
- Experience delivering enterprise reporting and data warehouse solutions.
- Exposure to Microsoft BI technologies and large-scale ETL implementations.
- Experience working in Agile or structured SDLC environments.
Key Competencies
- Technical Leadership
- Problem Solving and Analytical Skills
- Stakeholder Communication
- Team Collaboration and Mentoring
- Quality and Performance Focus
- Ability to managemultiple projects and production support activities.
