cover image
Mastech Digital

Senior ETL Developer

Hybrid

Phoenix, United states

Senior

Freelance

03-11-2025

Share this job:

Skills

Leadership Java Tableau Data Analysis SQL DevOps Architecture Programming power bi Shell Agile PL/SQL SQL/PLSQL

Job Specifications

NOTE: Only open for USC and Green card holders.

Must-Have Technical Expertise (5-7 Years)

Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL
Proficiency in developing and debugging the PL/SQL Code.
Develop SCD mappings with difference source formats using necessary Transformations.
Performance tuning of Targets, Source, Mappings, Sessions, and Workflows.
Design HTTP Transformations.
Experienced in handling the ETL Code deployments using DevOps Tools
Hands on knowledge with UNIX shell scripting and CA7 job scheduler
Intermediate level skills in data analysis and data modeling

Responsibilities:

Lead end-to-end ETL solution design and implementation.
Collaborate with business and technical teams to translate requirements into data workflows.
Align business strategy with software/data solutions.
Oversee code deployments using DevOps tools.
Optimize ETL performance (sources, mappings, workflows).
Provide technical leadership and mentoring to junior developers.
Participate in projects using Agile or Waterfall methodologies.

Nice-to-Have Skills (Flex Skills)

Experience with Alteryx.
Experience with BI tools (Microsoft Power BI / Tableau / Oracle BI).
Hands-on knowledge using Teradata.
Working knowledge of software design patterns and architecture.
Experience in Banking and Regulatory Reporting is a plus.
Any JAVA certifications are a plus.

About the Company

Welcome to Mastech Digital, a leading digital-first company that empowers global corporations through innovative digital transformation services. We specialize in analytics and AI-driven data modernization solutions and integrate them with our global expertise to source any digital and engineering technology skill set worldwide. Through a combination of people, processes, and technology, we help clients derive greater value from their digital transformation services programs. We help organizations across various industries... Know more