Data Engineer

Atos SE; Monterrey; Híbrido; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A leading IT services company is seeking a qualified candidate for a hybrid position in Monterrey, Mexico. You will be responsible for data analysis, ETL processes, and coordinating testing efforts. Ideal candidates will have 6-8 years of experience and expertise in PowerCenter. Join a dynamic team focused on delivering high-quality data solutions.

Formación

• 6-8 years of experience in data analysis and ETL processes.
• Proficient in using PowerCenter for data loading and transformation.
• Experience in coordinating testing with multiple teams.

Responsabilidades

• Analyze requirement specifications from clients.
• Prepare HLD and project plans based on functional specs.
• Review ETL design documents and define data constraints.
• Extract and transform data from various sources.
• Create and design mappings based on business requirements.
• Write test queries for data validation.
• Coordinate system and user acceptance testing.
• Fine tune mappings for performance improvements.

Conocimientos

Data analysis

ETL processes using PowerCenter

Data modeling

Testing coordination

Informatica tuning

Herramientas

PowerCenter Designer

Oracle

Descripción del empleo

Location

Mexico or Monterrey (hybrid position)

Work Experience

6-8 years

Key Responsibilities

• Analysis of the requirement specifications provided by the clients.
• Preparation of HLD, project plan based on the business functional spec.
• Review of ETL detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Analysis of Data model to check table constraints and columns in Data Mart. Extracting data from sources like Oracle and Flat Files using PowerCenter Designer and transforming them using the business logic and loading the data to the target warehouse.
• Understanding business requirement document and creating or designing mappings as per the business requirements using transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.
• Writing test queries on source data as per business requirement for balancing the target data.
• Coordination of system/Integration/UAT testing with other teams involved in project and review of test strategy. Used complex data transformations 11.
• Fine tuning Informatica PowerCenter mappings and sessions to improve performance. Coordinating with business and development teams for closure of UAT defects and creating ad hoc reports for end users.