Mastech Digital
Senior ETL Developer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior ETL Developer with a contract length of "unknown" and a pay rate of "unknown." Required skills include 5-7 years in Informatica PowerCenter, Oracle SQL/PLSQL, UNIX scripting, and DevOps tools. Banking experience is a plus.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
November 4, 2025
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Phoenix, AZ
-
🧠 - Skills detailed
#Tableau #BI (Business Intelligence) #Alteryx #Leadership #Oracle #SQL (Structured Query Language) #DevOps #"ETL (Extract #Transform #Load)" #Deployment #Teradata #Microsoft Power BI #Scripting #Debugging #Java #Programming #Shell Scripting #Unix #Data Modeling #Strategy #Agile #Informatica #Data Analysis
Role description
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.
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.
