ETL Lead

Truist • Greensboro, NC

159d

About The Position

Deliver technically complex solutions. Oversee the design, development, and maintenance of our Finance data integration solutions. This role will collaborate with data architects and business stakeholders, and ensure the delivery of high-quality, scalable, and efficient data pipelines.

Requirements

• Bachelor’s Degree and four to seven years of experience or equivalent education and software engineering training.
• Proficiency in ETL tools (e.g., Informatica, Ab Initio Talend, SSIS, DataStage).
• Strong SQL skills and experience with relational databases (e.g., Oracle, SQL Server, PostgreSQL).
• Experience running production support process.
• Proficiency in leading onshore/offshore model.
• Knowledge of software development lifecycles and CI/CD practices (GitLab/GitHub).
• Knowledge in getting data from Hive/Hadoop data sources.
• In-depth knowledge in information systems and ability to identify, apply, and implement IT best practices.
• Understanding of key business processes and competitive strategies related to the IT function.
• Ability to provide direction and mentor less experienced teammates.
• Ability to interpret and convey complex, difficult, or sensitive information.

Nice To Haves

• College degree in Computer Science, math or related field of study.
• Bachelor’s degree in computer science, computer engineering or related degree and eight years of experience or an equivalent combination of education and work experience.
• Knowledge of specific applications, technology platforms, programming languages, systems, or business segments.
• Hands-on experience in data integration, ETL frameworks, and enterprise data warehousing.
• Banking or financial services experience.
• Knowledge of one or more of the following: Solid foundation in data structures, algorithms, and software design with strong analytical and debugging skills.
• Experience with Open-Source tools and frameworks.
• Experience with cloud technologies, such as AWS, Azure, or GCP.
• Experience using web servers, application containers, caching technologies.
• Solid knowledge of relational database design and development (SQL, stored procedures, data modeling).

Responsibilities

• Develop customized coding, software integration, perform analysis, configure solutions, using tools specific to the project or the area.
• Lead and participate in the development, testing, implementation, maintenance, and support of highly complex solutions in adherence to company standards, including robust unit testing and support for subsequent release testing.
• Build non-functional monitoring capabilities and provide escalated support for highly complex applications in production.
• Build in and maintain security controls and monitoring in support of company standards.
• Typically lead moderately complex projects and participate in larger, more complex initiatives.
• Solve complex technical and operational problems.
• Act as a resource for teammates with less experience.
• May oversee the work of a small team.
• Responsible for delivering high quality working software and automating manual/reusable tasks working directly, and engage with, the business from the beginning of the design work.
• Leverage continuous engineering practices to deliver business value regarding effectiveness of the design.
• Actively participate in refining user stories.
• Responsible for design, developing, and maintaining automated unit testing, and supporting integration and functional testing.
• Responsible for providing automated monitoring capabilities, providing warranty support, and providing knowledge transfer to production support.
• Develop code in accordance with the acceptance criteria established by the Product Owner.

Benefits

• Medical, dental, vision, life insurance, disability, accidental death and dismemberment.
• Tax-preferred savings accounts.
• 401k plan.
• No less than 10 days of vacation during the first year of employment.
• 10 sick days.
• Paid holidays.
• Defined benefit pension plan, restricted stock units, and/or a deferred compensation plan may be available.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees