Lead ETL Developer

2 days ago


O'Fallon, United States ShiftCode Analytics Full time

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:
  1. Successfully lead major projects and complex assignments with broad scope and long-term business implications.
  2. Create solutions with high level of innovation, cost effectiveness, high quality and faster time to market.
  3. Lead day to day system development and maintenance activities of the team to meet service level agreements (SLAs).
  4. Partner with Project Managers in implementation of processes per the evolving needs of the team and the solutions.
  5. 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.
  6. Ensure adequate test coverage in Unit Testing, System Testing/Integration Testing and Performance Testing.
  7. 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.
  8. Coordinate offshore development and manage day to day activities. Support collection and reporting of project and software metrics.
  9. Actively look for opportunities to enhance standards and improve process efficiency. Mentor and guide other team members during all phases of the SDLC.
  10. 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.
  11. Ensure compliance to the defined standards. Actively look for opportunities to modify and enhance standards per the needs of the department.
  12. Develop documentation templates, lead and enforce development of documentation throughout the development lifecycle of the solution.
  13. Ensure compliance of Audit Requirements by proactively educating team on Compliance Requirements and Integrating Compliance Requirements in SDLC.
Required Qualifications:
  1. Bachelor's degree in Information Systems, Information Technology, Computer Science, Engineering or equivalent experience
  2. Strong experience with SQL and PL/SQL development
  3. Experience working with relational databases such as SQL Server, Oracle, Postgres
  4. Proficient in building ETL pipelines with ETL tools like SSIS or Informatica
  5. Understanding of database design and modeling, performance tuning, and stored procedures
  6. Excellent analytical, collaboration and communications skills
    Critical thinking, logical reasoning and experience gathering and understanding business requirements to build ETL pipelines
  7. 5+ years of experience in related field, including experience in delivering secure solutions in Financial Services Sector
  8. Advanced knowledge and understanding of Software Engineering Concepts and Methodologies
Preferred Qualifications:
  1. Experience building dashboards with BI tools like Power BI, Tableau

  • Qlik Developer

    2 weeks ago


    O'Fallon, United States Diverse Lynx Full time

    Roles & Responsibilities • Data Architecture, Modeling & Advanced Visualization Development: • Design and implement robust data models within QlikSense, optimizing for performance and data accessibility across complex datasets. • Create complex data transformations and data cleansing routines using the Qlik Sense data load script. • Manage data...


  • O'Fallon, United States MasterCard Full time

    Data-Driven Decision MakingAt Mastercard, we believe in the power of data to drive business decisions. As a Data Engineer II, you will play a key role in developing and maintaining analytics systems that provide actionable insights to our stakeholders.Your Key ResponsibilitiesDevelop and maintain analytics systems that provide actionable insights to our...

  • Lead Developer Role

    3 weeks ago


    O'Fallon, United States MasterCard Full time

    Our VisionAt Mastercard, we envision a world where financial inclusion is a reality for all. We believe in the power of innovation and collaboration to create a more sustainable and inclusive global economy.As a leader in digital payments, we support a wide range of payment choices, making transactions secure, simple, smart, and accessible. Our technology...


  • O'Fallon, United States Citigroup Inc Full time

    Company Overview:Citigroup Inc., a leading global financial services institution, is seeking an experienced Technical Lead Software Developer to join its team. As a key member of the Applications Development group, you will play a critical role in designing and developing scalable, secure, and reliable software applications.Job Description:As a Technical...


  • O'Fallon, United States MasterCard Full time

    A Day in the LifeAs a Principal Software Engineer at Mastercard, you'll be part of a dynamic team dedicated to delivering innovative software solutions.You'll work closely with stakeholders to understand business requirements and translate them into technical solutions.Your responsibilities will include:Architecting, designing, and developing high-performing...


  • O'Fallon, United States ShiftCode Analytics Full time

    At ShiftCode Analytics, we are seeking a highly skilled Lead Java Software Developer to join our team. As a lead developer, you will be responsible for designing, developing, and maintaining complex software systems.You will work closely with cross-functional teams to identify and prioritize development needs, and collaborate with QA engineers to develop and...


  • O'Fallon, United States Citigroup Inc Full time

    Key ResponsibilitiesWe are looking for an experienced Technical Lead who can oversee the development of our software applications. Your primary responsibilities will include creating prototypes, pilots, and technical proof of concepts to ensure integration of functions to meet business goals and objectives. Additionally, you will partner with management...


  • O'Fallon, United States MasterCard Full time

    Our PurposeMastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships...


  • O'Fallon, United States Waterway Carwash Full time

    About Us:Waterway Carwash is a leading provider of car wash services, dedicated to delivering exceptional customer experiences. Our Learn to Lead program is designed for individuals who are passionate about leadership and want to develop their skills in a fast-paced environment.Career Advancement Opportunities:We offer career advancement opportunities for...

  • Lead FinOps Analyst

    2 weeks ago


    O'Fallon, United States MasterCard Full time

    Our PurposeMastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships...


  • O'Fallon, Missouri, United States Circle K Stores, Inc. Full time

    Job DescriptionWe are seeking a Car Wash Site Manager C to lead our car wash site in [Location]. The ideal candidate will have a strong background in sales management, customer service, and team building. They will be responsible for managing the day-to-day operations of the site, including scheduling employee shifts, managing operating P&L metrics, and...


  • O'Fallon, United States MasterCard Full time

    Our PurposeMastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships...


  • O'Fallon, United States MasterCard Full time

    Our PurposeMastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships...


  • O'Fallon, United States Citigroup Inc Full time

    Citibank, N.A. seeks an Applications Development Technical Lead Analyst for its O’Fallon, MO location. Duties: Develop design and code artifacts and software that is scalable, secure, and reliable. Create solutions with prototypes, pilots, and technical proof of concepts. Identify and define system enhancements and quality improvements. Partner with...


  • O'Fallon, United States Citigroup Inc Full time

    Citibank, N.A. seeks an Applications Development Technical Lead Analyst for its O'Fallon, MO location.Duties: Develop design and code artifacts and software that is scalable, secure, and reliable. Create solutions with prototypes, pilots, and technical proof of concepts. Identify and define system enhancements and quality improvements. Partner with...


  • O'Fallon, United States Damco Solutions Full time

    Job OverviewWe are seeking a highly skilled Sr. Java Developer to join our technical team at Damco Solutions.About the RoleThe successful candidate will be responsible for developing and maintaining high-quality Java-based applications, collaborating with cross-functional teams, and driving end-to-end development.Key ResponsibilitiesDesign, develop, and...


  • O'Fallon, United States MasterCard Full time

    Our VisionDriving Innovation and ExcellenceAs a global technology company, Mastercard is dedicated to delivering cutting-edge solutions that meet the evolving needs of our customers. We're constantly pushing the boundaries of what's possible, and we're looking for talented individuals like you to help us achieve our goals.We're seeking an experienced Manual...


  • O'Fallon, United States MasterCard Full time

    Our Purpose Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships...

  • Technical Lead

    4 days ago


    O'Fallon, Missouri, United States Wipro Full time

    We are seeking a Technical Lead to lead our team of automation specialists. As a Technical Lead, you will be responsible for overseeing the design and implementation of CI/CD pipelines, ensuring they meet the required standards and are aligned with business objectives. You will also mentor junior team members and provide guidance on technical decisions.Key...


  • O'Fallon, United States MasterCard Full time

    About Us\Mastercard is a global leader in payment technologies and innovations, enabling individuals, financial institutions, governments, and businesses to realize their greatest potential. Our vision is to connect and power an inclusive digital economy that benefits everyone, everywhere.\We are driven by our 'Mastercard Way' cultural values, which include...