Datastage Developer Sr

hace 5 meses

México Derevo A tiempo completo

About Us:
At Derevo, we are dedicated to empowering businesses and individuals to unleash the value of data within organizations. We achieve this by implementing analytics processes and platforms with a comprehensive approach covering the entire cycle necessary to achieve it.

Derevo started in 2010 with a simple idea - to create more than a company, but a community and a space where everyone has the opportunity to build a dream.

At Derevo, we believe in human talent that is free and creative. Being human is our superpower

**Data Stage Developer Sr**

The desired profile should have at least 5 years hands-on experience in designing, establishing, and maintaining data management and storing systems. Skilled in collecting, processing, cleaning, and deploying large datasets, understanding ER data models, and integrating with multiple data sources. Efficient in analyzing, communicating, and proposing different ways of building Data Warehouses, Data Lakes, End-to-End Pipelines, and Big Data solutions to clients, either in batch or streaming strategies.

**What We Ask For?**
- Advanced english
- SQL:
Data Definition Language, Data Manipulation Language, Intermediate/advanced queries for analytical purpose, Subqueries, CTEs, Data types, Joins with business rules applied, Grouping and Aggregates for business metrics, Indexing and optimizing queries for efficient ETL process, Stored Procedures for transforming and preparing data, SSMS, DBeaver
- **3+ YOE IBM Data Stage**:
Senior-level DataStage developer with at least 4-5 years of relevant experience in DataStage development who can work independently with limited oversight. Must have experience with IBM Infosphere Information Server v11.7

Work with Client’s in-house development team to understand activities required to ensure data is acquired from Origami, proper transformations are applied, and the resulting data is loaded into the existing Oracle Data Warehouse

Update existing or create new DataStage jobs required to support the movement of data to the existing Oracle Data Warehouse

Provide deployment and system testing support
- Azure (desirable):
Intermediate/Advanced knowledge in

Azure Storage Account:
Provision Azure Blob Storage or Azure Data Lake instances

Build efficient file systems for storing data into folders with static or parametrized names, considering possible security rules and risks

Experience identifying use cases for open-source file formats like parquet, AVRO, ORC

Understanding optimized column-oriented file formats vs optimized row-oriented file formats

Implementing security configurations through Access Keys, SAS, AAD, RBAC, ACLs

Azure Data Factory:
Provision Azure Data Factory instances

Use Azure IR, Self-Hosted IR, Azure-SSIS to establish connections to distinct data sources

Use of Copy or Polybase activities for loading data

Build efficient and optimized ADF Pipelines using linked services, datasets, parameters, triggers, data movement activities, data transformation activities, control flow activities and mapping data flows

Build Incremental and Re-Processing Loads

What Benefits You'll Have?
- WELLNESS: We prioritize your overall well-being through personal, professional, and economic balance. Our statutory and additional benefits will assist you in achieving this.
- LET´S RELEASE YOUR POWER: You will have the opportunity to specialize comprehensively in different areas and technologies, achieving interdisciplinary development. We encourage you to set new challenges and surpass yourself.
- WE CREATE NEW THINGS: Thinking outside the box is our forte. You'll have the space, trust, and freedom to create, along with the necessary training to achieve it.
- WE GROW TOGETHER: Participate in cutting-edge, multinational technological projects with foreign teams.

Where Will You Work? We are a dynamic team operating in a remote setting. We offer flexibility and structure, providing the necessary equipment and internal communication tools to facilitate our operation and that of our clients.

If you meet most of the requirements and find the profile interesting, do not hesitate to apply. Our Talent team will contact you

Become a Derevian & develop your superpower

  • Senior DataStage Developer

    hace 2 meses

    Ciudad de México, Ciudad de México nFolks Ltd A tiempo completo

    Job Opportunity We are seeking a highly skilled Sr DataStage Developer to join our team at nFolks Data Solutions LLC. As a key member of our data integration team, you will be responsible for designing, developing, and implementing data pipelines using DataStage. Responsibilities: * Design and develop data pipelines using DataStage * Collaborate with...

  • Senior DataStage Developer

    hace 1 mes

    Ciudad de México, Ciudad de México nFolks Ltd A tiempo completo

    Sr DataStage DeveloperWe are seeking a highly skilled Sr DataStage Developer to join our team at nFolks Data Solutions LLC.About the Role:Design, develop, and implement data integration solutions using DataStage.Collaborate with cross-functional teams to identify business requirements and develop data integration strategies.Ensure data quality, integrity,...

  • DataStage Developer

    hace 1 mes

    Ciudad de México, Ciudad de México Syncreon Consulting A tiempo completo

    Job Title: DataStage DeveloperWe are seeking a highly skilled DataStage Developer to join our team at Syncreon Consulting.Job SummaryThe successful candidate will be responsible for designing, developing, and implementing ETL applications using DataStage and SQL. They will lead a team of ETL developers, perform root cause analysis, and develop effective...

  • DataStage Developer

    hace 2 semanas

    Ciudad de México, Ciudad de México Syncreon Consulting A tiempo completo

    Job Title: Senior DataStage DeveloperJob Summary:We are seeking a highly skilled Senior DataStage Developer to join our team at Syncreon Consulting. As a Senior DataStage Developer, you will be responsible for designing, developing, and implementing ETL applications using DataStage and SQL.Key Responsibilities:Lead a team of ETL developers and perform root...

  • DataStage Developer

    hace 4 semanas

    Ciudad de México, Ciudad de México Syncreon Consulting A tiempo completo

    Job Title: DataStage DeveloperJob Summary:We are seeking a highly skilled DataStage Developer to join our team at Syncreon Consulting. As a DataStage Developer, you will be responsible for designing, developing, and implementing ETL applications using DataStage and SQL.Key Responsibilities:Lead a team of ETL developers and perform root cause analysis to...

  • Datastage Developer

    hace 3 días

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperJob Summary:We are seeking a skilled ETL/Datastage Developer to join our team in Mexico. The successful candidate will be responsible for designing and building scalable DataStage solutions, troubleshooting problems in ETL system designs and processes, and providing DataStage tool administration functions. The ideal...

  • Senior DataStage Developer

    hace 7 días

    Ciudad de México, Ciudad de México Syncreon Consulting A tiempo completo

    Job Title: Senior DataStage DeveloperJob Summary:We are seeking a highly skilled Senior DataStage Developer to join our team at Syncreon Consulting. As a Senior DataStage Developer, you will be responsible for contributing to the development of ETL applications and processes in our IT Data Team.Key Responsibilities:Lead a team of ETL developers and perform...

  • Datastage Developer

    hace 1 mes

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperAbout the Role:We are seeking a highly skilled ETL/Datastage Developer to join our team in CDMX, Ciudad de México (MX). As a key member of our team, you will be responsible for designing and building scalable DataStage solutions, updating data within repositories, data marts, and data warehouses, and troubleshooting...

  • Senior DataStage Developer

    hace 2 meses

    Ciudad de México, Ciudad de México Syncreon Consulting A tiempo completo

    Job DescriptionJob Title: Senior DataStage DeveloperJob Summary:We are seeking a highly skilled Senior DataStage Developer to join our team at Syncreon Consulting. As a Senior DataStage Developer, you will be responsible for designing, developing, and implementing ETL applications and processes in our IT Data Team.Key Responsibilities:Lead a team of ETL...

  • ETL/Datastage Developer

    hace 1 semana

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperWe are seeking a skilled ETL/Datastage Developer to join our team in Mexico. The ideal candidate will have experience in designing and building scalable DataStage solutions, updating data within repositories, data marts, and data warehouses, and troubleshooting problems in ETL system designs and processes.Key...

  • ETL/Datastage Developer

    hace 2 semanas

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperJob Summary:We are seeking an experienced ETL/Datastage Developer to join our team in CDMX, Ciudad de México (MX). The successful candidate will design and build scalable DataStage solutions, troubleshoot problems in ETL system designs and processes, and provide DataStage tool administration functions.Key...

  • ETL/ Datastage Developer

    hace 1 semana

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/ Datastage DeveloperJob Summary:We are seeking a skilled ETL/ Datastage Developer to join our team in CDMX, Ciudad de México (MX). The ideal candidate will have experience in designing and building scalable Datastage solutions, updating data within repositories, data marts, and data warehouses, and troubleshooting problems in ETL system...

  • ETL/Datastage Developer

    hace 1 mes

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperAbout the Role:We are seeking an experienced ETL/Datastage Developer to join our team in CDMX, Ciudad de México (MX). As a key member of our team, you will be responsible for designing and building scalable DataStage solutions, updating data within repositories, data marts, and data warehouses, and troubleshooting problems...

  • Senior Data Stage Developer

    hace 1 mes

    Ciudad de México, Ciudad de México nFolks Ltd A tiempo completo

    Sr DataStage DeveloperWe are seeking a highly skilled Sr DataStage Developer to join our team at nFolks Data Solutions LLC.Job Summary:The successful candidate will be responsible for designing, developing, and implementing data integration solutions using DataStage.Key Responsibilities:Design and develop data integration workflows using DataStageImplement...

  • ETL/Datastage Developer

    hace 2 semanas

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperJob Summary:NTT DATA Services is seeking an experienced ETL/Datastage Developer to join our team in CDMX, Ciudad de México (MX). As a key member of our team, you will be responsible for designing and building scalable DataStage solutions, updating data within repositories, data marts, and data warehouses, and...

  • Senior Data Stage Developer

    hace 4 semanas

    Ciudad de México, Ciudad de México nFolks Ltd A tiempo completo

    Sr DataStage DeveloperWe are seeking a highly skilled Sr DataStage Developer to join our team at nFolks Data Solutions LLC.Key Responsibilities:Design, develop, and implement data integration solutions using DataStage.Collaborate with cross-functional teams to ensure data quality and integrity.Optimize data processing and transformation...

  • Senior ETL/Datastage Developer

    hace 6 días

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: Senior ETL/Datastage DeveloperWe are seeking a skilled Senior ETL/Datastage Developer to join our team at NTT DATA Services. As a key member of our team, you will be responsible for designing and building scalable DataStage solutions, updating data within repositories, data marts, and data warehouses, and troubleshooting problems in ETL system...

  • ETL/Datastage Developer

    hace 2 semanas

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperAbout the Role:We are seeking a highly skilled ETL/Datastage Developer to join our team in Mexico. As a key member of our team, you will be responsible for designing and building scalable Datastage solutions, updating data within repositories, data marts, and data warehouses, and troubleshooting problems in ETL system...

  • ETL/Datastage Developer

    hace 1 mes

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperAbout the Role:We are seeking an experienced ETL/Datastage Developer to join our team in CDMX, Ciudad de México (MX). As a key member of our team, you will be responsible for designing and building scalable DataStage solutions, updating data within repositories, data marts, and data warehouses, and troubleshooting problems...

  • ETL/Datastage Developer

    hace 4 semanas

    Ciudad de México, Ciudad de México NTT DATA A tiempo completo

    Job Title: ETL/Datastage DeveloperAbout the Role:We are seeking an experienced ETL/Datastage Developer to join our team in CDMX, Ciudad de México (MX). As a key member of our team, you will be responsible for designing and building scalable DataStage solutions, updating data within repositories, data marts, and data warehouses, and troubleshooting problems...