Lead ETL Developer : Mastercard - ShiftCode Analytics : Job Details

Lead ETL Developer : Mastercard

ShiftCode Analytics

Job Location : O Fallon,MO, USA

Posted on : 2025-08-05T07:46:44Z

Job Description :

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
  • Apply Now!

    Similar Jobs ( 0)