Senior ETL Developer

Job Title : ETL Lead Developer

Location : Dallas, TX, Pittsburgh, PA, Cleveland, OH (Onsite)

Type : Fulltime with Mastech Digital

. 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.

. Provides reviews of the deliverables and identifies 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.

. Fulfil and design the development for logical data models as well as physical data models.

. Proposes, designs & codes software solutions to address complex business needs. Oversees technical and procedural documentation required

. 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

. Strong agile/scrum development experience

. Strong collaboration and communication skills within distributed project teams

. Excellent written and verbal communication skills