ETL Production Support Engineer

Job Title: ETL Production Support Engineer Consultant

Duration: 12 months with extension possible to 18 months

Location: Chandler, AZ (3 days per week onsite)

Pay Scale: $60-65/hr W2 (Cannot subcontract or C2C)

Job Description:

Matlen Silver is actively recruiting for an ETL Production Support Engineer Consultant to work for our client's production support team just outside of Phoenix in Chandler, AZ to provide front line technical support to end users throughout the U.S. This includes responding to issues related to Problem/Incident Management, Release/Deployment, Operational Readiness, Application Monitoring, Production Governance related to issues. This role is a hybrid work model that requires 3 days onsite per week in the client's Chandler office.

Responsibilities:

• Provides monitoring and support for triaging ETL problems and coordinating with various support teams across the organization including activities related to application incident and problem management.
• Performs root cause analysis and communicates with the line of business and management the overall status and health of the application throughout the support process.
• Looks for areas of improvement in monitoring, application stability, and speed of determining root cause.
• Performs troubleshooting, analysis, research and resolution using advanced query and scripting skills.
• Work closely with Technology Infrastructure Teams, Development & Testing Teams in supporting Integrated / Independent releases, software/hardware upgrades, server upgrades.
• Performs real-time restoration and triaging of issues impacting technical services (application/infrastructure) to customers and partners in a timely manner while keeping partners advised of significant progress or challenges during the restoration period.

Required Experience:

1. Informatica PowerCenter/Cloud Data Integration (CDI) Development knowledge:

• Understanding ETL/ELT concepts and performance tuning
• IDMC deployment and migration processes
• Monitoring logs and platform health
• Data warehouse concepts (Oracle, Teradata, SQL Server)

2. Unix/Linux knowledge (basic commands/file update(vi)/scripting)

3. Understanding of SQL databases, APIs, AWS/Azure/Snowflake, and on-prem systems.

4. Autosys Batch Job scheduling

5. Troubleshooting & Operational Support

• Log analysis (DIS, Agent Core, Audit logs)
• Incident triage and RCA
• Job failure analysis and performance tuning
• Coordination with DBA, Unix, Network, and Storage teams

6. Splunk/Dynatrace/Service Now knowledge is nice to have

About Matlen Silver

Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works.

Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status.

If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: [email protected] // 908-393-8600.