Lead ETL Developer Mastercard

Interview : Coidng test + Video

Visa : USC, GC, GC EAD, H4, L2

This is hybrid from day-1

Description :

Technical requirements:

SQL and PL/SQL

ETL Development (They use SSIS but Informatica is also fine) Big Plus:

Financial services experience

Big Data exp: Spark, Nifi pipelines, data bricks

Working with Power BI and Tableau

Python

Job Overview:

Leads software engineering projects and creates the development and delivery of enhanced software solutions. Researches alternative technical solutions for changing business needs. Responsible for assuring the daily activities of the team meet the requirements of SLA's.

Responsibilities:

Successfully lead major projects and complex assignments with broad scope and long-term business implications.

Create solutions with high level of innovation, cost effectiveness, high quality and faster time to market.

Lead day to day system development and maintenance activities of the team to meet service level agreements (SLAs).

Partner with Project Managers in implementation of processes per the evolving needs of the team and the solutions.

Create detailed cost and time estimates for implementing business solutions, define technical scope and requirements of the project and assist project manager with managing scope during the lifecycle of the project.

Ensure adequate test coverage in Unit Testing, System Testing/Integration Testing and Performance Testing.

Perform Quality Inspections and Walkthroughs throughout the SDLC including Requirements Review, Architecture Review, Design Review, Code Review and Security Review to ensure compliance with Client standards.

Coordinate offshore development and manage day to day activities. Support collection and reporting of project and software metrics.

Actively look for opportunities to enhance standards and improve process efficiency. Mentor and guide other team members during all phases of the SDLC.

Lead and guide team through all phases of the SDLC of an application. Successfully lead production incident and problem management, identification of root cause and remediation of the problems. Mentor, coach and assist project team members.

Ensure compliance to the defined standards. Actively look for opportunities to modify and enhance standards per the needs of the department.

Develop documentation templates, lead and enforce development of documentation throughout the development lifecycle of the solution.

Ensure compliance of Audit Requirements by proactively educating team on Compliance Requirements and Integrating Compliance Requirements in SDLC.

Required Qualifications:

Bachelor's degree in Information Systems, Information Technology, Computer Science, Engineering or equivalent experience

Strong experience with SQL and PL/SQL development

Experience working with relational databases such as SQL Server, Oracle, Postgres

Proficient in building ETL pipelines with ETL tools like SSIS or Informatica

Understanding of database design and modeling, performance tuning, and stored procedures

Excellent analytical, collaboration and communications skills

Critical thinking, logical reasoning and experience gathering and understanding business requirements to build ETL pipelines

5+ years of experience in related field, including experience in delivering secure solutions in Financial Services Sector

Advanced knowledge and understanding of Software Engineering Concepts and Methodologies

Preferred Qualifications:

Experience building dashboards with BI tools like Power BI, Tableau