What are the responsibilities and job description for the ETL Engineer position at wellsfargo?
Title: ETL Engineer
Location:
Addison, TX
Charlotte, NC
Duration: 12 months
Work Engagement: W-2
Benefits on offer for this contract position: Health Insurance, Life insurance, 401K and Voluntary Benefits
Summary:
In this contingent resource assignment, you may: Consult on or participate in moderately complex initiatives and deliverables within Software Engineering and contribute to large-scale planning related to Software Engineering deliverables. Review and analyze moderately complex Software Engineering challenges that require an in-depth evaluation of variable factors. Contribute to the resolution of moderately complex issues and consult with others to meet Software Engineering deliverables while leveraging solid understanding of the function, policies, procedures, and compliance requirements. Collaborate with client personnel in Software Engineering.
Responsibilities:
Experienced in developing and supporting Ab Initio and Teradata based complex Data Warehousing applications as well as the ability to upskill to open source based modern technologies. Should have expertise in full SDLC for Data Management apps and be able to debug production issues and drive incident calls with hands on approach towards resolution.
Qualifications:
- Applicants must be authorized to work for ANY employer in the U.S. This position is not eligible for visa sponsorship.
- Strong & Hands-on development experience with various Ab Initio components (GDE, Express>It, Conduct>It, Continuous>Flows, Metadata Hub, EME, PDL/Meta-programming etc.)
- Good working experience on generic graphs, parallelism techniques and with all components of Ab Initio such as Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup etc.
- Experience and expertise in Teradata, PL/SQL and Unix shell scripting.
- Financial services experience is a plus and data warehousing experience is required.
- Strong technical experience in the areas of data analysis, database design and ETL.
- Strong technical experience in Design (Mapping specifications, HLD, LLD), Development (Coding, Unit testing) using Ab Initio
- Must have the ability to relate to both business and technical members of the team and possess excellent communication skills
- Proactively notify risks, bottlenecks, problems, issues, and concerns, and plan upon remediation of these
- Work closely with Quality Control teams to deliver quality software to agreed project schedules.
