Senior ETL Developer

Pyramid Consulting, Inc; México; Remoto; MXN 350.000 - 550.000; Tempo pieno

Descrizione del lavoro

Pyramid Consulting, Inc. is seeking an ETL Developer specialized in DataStage and SQL for a remote role based in Mexico.

The position focuses on designing, building, testing, and maintaining ETL batch processes while collaborating with business users and cross-functional teams. The ideal candidate will have strong SQL and PL/SQL skills and experience in data analysis, troubleshooting, and translating business requirements into technical designs.

Competenze

• Must have skills: Client DataStage and SQL.
• Strong SQL/Database concepts with PL/SQL experience.
• Excellent communication to work with business users and cross-functional teams.

Mansioni

• Design, develop, test, and maintain ETL batch processes using DataStage.
• Strong SQL focus with PL/SQL experience.
• Troubleshoot and resolve complex data issues including root cause analysis.
• Analyze business requirements and translate into technical designs.
• Establish criteria for data use and test cases.

Conoscenze

DataStage

SQL

Strumenti

Unix

Azure Data Factory

WebFOCUS

Descrizione del lavoro

Job Title: ETL Developer – DataStage & SQL

Employment Type: Full-Time

Location: Mexico

Work Model: Remote

Skills:

Role & Responsibilities:

Must have Skills- Client DataStage, SQL

Good to have- Unix, US Healthcare & Insurance, Azure Data Factory, WebFOCUS.

Detailed Job Description-

• Design, Develop, test, and maintain ETL batch processes using Client DataStage
• Strong SQL/Database concepts, with relevant experience on PL/SQL
• Excellent oral and written communication skills, to be able to work with business users and cross functional teams
• Troubleshooting- Identify and resolve complex data related issues including conducting Root cause analysis
• Data Analysis- Analyze business requirements and translate them into technical designs
• Experience in establishing criteria for data use/test cases.