ETL Lead Developer

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