Datastage Developer Sr

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