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