Job Description
Job Title : ETL Lead Developer
\n
Location : Dallas, TX, Pittsburgh, PA, Cleveland, OH (Onsite)
\n
Type : Fulltime with Mastech Digital
\n
\n
. 6- 8 years of experience working in relational database design with Oracle and Teradata
\n
. Proficient in Informatica, with a good knowledge of ETL development
\n
. Strong experience in design, building and testing the Extract, Transform, and Load (ETL) applications
\n
. Experience working with enterprise data warehouses
\n
. Familiarity extracting data from multiple data sources such as DB2, Oracle, and flat files
\n
. Familiarity with database stored procedures
\n
. Strong SQL experience required
\n
. Experience working in Linux environment and Shell scripting
\n
. Provide end user support including business queries and requests.
\n
. Provides reviews of the deliverables and identifies gaps and areas of improvement.
\n
. Maintain in depth and up to date knowledge of standards, guidelines, and industry trends for Data Integration, Data Migration and Architectures.
\n
. Fulfil and design the development for logical data models as well as physical data models.
\n
. Proposes, designs & codes software solutions to address complex business needs. Oversees technical and procedural documentation required
\n
. Provides technical guidance and support to colleagues and solution development
\n
. Displays an innovative approach to apply modern principles, methodologies and tools to advance business initiatives and capabilities
\n
. Strong agile/scrum development experience
\n
. Strong collaboration and communication skills within distributed project teams
\n
. Excellent written and verbal communication skills
\n