ETL Developer (Software Engineer II) at Truist Bank

The position is described below. If you want to apply click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application youll be invited to create a profile which will let you see your application status and any communications. If you already have a profile with us you can log in to check status.Need HelpIf you have a disability and need assistance with the application you can request a reasonable accommodation. Send an email to Accessibility (accommodation requests only; other inquiries wont receive a response).Regular or Temporary:RegularLanguage Fluency: English (Required)Work Shift:1st shift (United States of America)Please review the following job description:Are you passionate about turning data into actionable insights Were looking for an ETL Developer who thrives in dynamic enterprise-level environments and loves building scalable high-performance data solutions.In this role youll design and optimize ETL workflows that power critical business decisions. Youll work with cutting-edge technologies including the Hadoop ecosystem data processing frameworks and large-scale integrations. Your expertise in extracting transforming cleansing and loading data across diverse systems will ensure accuracy and reliability at every step.Youll develop ETL mappings to move data seamlessly from source systems to data warehouses and data lakes enabling advanced analytics and innovation. If youre detail-oriented collaborative and ready to tackle complex challenges in a fast-paced setting we want to hear from you!This is a full-time onsite position (5 days per week) based in Atlanta GA; Charlotte NC; Raleigh NC; Richmond VA; Dallas TX or Greensboro NC.Essential Duties and Responsibilities:Following is a summary of the essential functions for this job. Other duties may be performed both major and minor which are not mentioned below. Specific activities may change from time to time. 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 experienceMay oversee the work of a small team.In an Agile environment: 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.Required QualificationsThe requirements listed below are representative of the knowledge skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Bachelors Degree and four to seven years of experience or equivalent education and software engineering training or experienceIn-depth knowledge in information systems and ability to identify apply and implement IT best practicesUnderstanding of key business processes and competitive strategies related to the IT functionAbility to plan and manage projects and solve complex problems by applying best practicesAbility to provide direction and mentor less experienced teammates. Ability to interpret and convey complex difficult or sensitive informationPreferred Qualificationsbachelors 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.Banking or financial services experience.Abnitio/Informatica BDM Experience.Skills in designing and developing extract transform and load ETL processes.Strong understanding of Informatica ETL tool .Create and maintain adequate documentation of project ETL design technical artifacts and ETL environment.Very Large Database and DW Implementation experience (20 TBs) well versed in SQL Oracle .Experience on Hadoop(HDFS) concepts HQL SQL and UnixExperience and ability to deliver results quickly in a fast-paced environment on multiple projects.Agile Delivery ExperienceGeneral Description of Available Benefits for Eligible Employees of Truist Financial Corporation: All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits though eligibility for specific benefits may be determined by the division of Truist offering the offers medical dental vision life insurance disability accidental death and dismemberment tax-preferred savings accounts and a 401k plan to teammates. Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by full-time or part-time status) during their first year of employment along with 10 sick days (also prorated) and paid holidays. For more details on Truists generous benefit plans please visit our Benefits site. Depending on the position and division this job may also be eligible for Truists defined benefit pension plan restricted stock units and/or a deferred compensation plan. As you advance through the hiring process you will also learn more about the specific benefits available for any non-temporary position for which you apply based on full-time or part-time status position and division of work.Truist is an Equal Opportunity Employer that does not discriminate on the basis of race gender color religion citizenship or national origin age sexual orientation gender identity disability veteran status or other classification protected by law. Truist is a Drug Free Workplace.EEO is the Law E-Verify IER Right to Work Key Skills SQL,Pentaho,PL/SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle Employment Type : Full-Time Experience: years Vacancy: 1