ETL Lead Developer
System One · Pittsburgh, Allegheny County ·
- Seniority
- Lead
- Employment
- Full time
Job Title: ETL Lead Developer
Location: Pittsburgh, Pennsylvania
Type: Permanent Full Time
Work Model: Hybrid – onsite and remote
Responsibilities
- Aligns business strategy with software solutions.
- Proposes, designs & codes software solutions to address complex business needs.
- Oversees technical and procedural documentation required.
- Leads complex problem solving.
- Provides technical guidance and support to colleagues and solution development.
- Displays an innovative approach to apply modern principles, methodologies, and tools to advance business initiatives and capabilities.
Requirements
- 6-8 years of experience working in relational database design with Oracle and Teradata.
- Proficient in Informatica, with a good knowledge of ETL development.
- Strong experience in design, building, and testing the Extract, Transform, and Load (ETL) applications.
- Experience working with enterprise data warehouses.
- Familiarity extracting data from multiple data sources such as DB2, Oracle, and flat files.
- Familiarity with database stored procedures.
- Strong SQL experience required.
- Experience working in Linux environment and Shell scripting.
- Provide end user support including business queries and requests.
- Provide reviews of the deliverables and identify gaps and areas of improvement.
- Maintain in-depth and up-to-date knowledge of standards, guidelines, and industry trends for Data Integration, Data Migration, and Architectures.
- Fulfill and design the development for logical data models as well as physical data models.
- Propose, design & code software solutions to address complex business needs.
- Oversee technical and procedural documentation required.
- Provide technical guidance and support to colleagues and solution development.
- Display an innovative approach to apply modern principles, methodologies and tools to advance business initiatives and capabilities.
- Strong agile/scrum development experience.
- Strong collaboration and communication skills within distributed project teams.
- Excellent written and verbal communication skills.
#M-
#LI-
Ref: #404-IT Pittsburgh