Data Engineer
Monterrey, MX
About Atos Group
Atos Group is a global leader in digital transformation with c. 70,000 employees and annual revenue of c. € 10 billion, operating in 67 countries under two brands — Atos for services and Eviden for products. European number one in cybersecurity, cloud and high-performance computing, Atos Group is committed to a secure and decarbonized future and provides tailored AI-powered, end-to-end solutions for all industries. Atos is a SE (Societas Europaea) and listed on Euronext Paris.
The purpose of Atos is to help design the future of the information space. Its expertise and services support the development of knowledge, education and research in a multicultural approach and contribute to the development of scientific and technological excellence. Across the world, the Group enables its customers and employees, and members of societies at large to live, work and develop sustainably, in a safe and secure information space.
Data Engineer
Location: Mexico or Monterrey (hybrid position)
Work Experience :6-8 years
Key responsibility:
- 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 Power center 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 Power Center 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.
Language: English fluent
#LI_MEX