Data stage developer

SN

Required Information

Details

1

Role**

Developer/Sr Developer

2

Required Technical Skill Set**

Datastage SQL

3

No of Requirements**

4

Desired Experience Range**

5

Location of Requirement

Bangalore/Hyderabad/Chennai/Pune

Desired Competencies (Technical/Behavioral Competency)

MustHave**

(Ideally should not be more than 35)

1. In depth Knowledge on Datastage

2. Knowledge of ETL process to facilitate smooth transfers and storage of data

3. Scripting skills using Python

GoodtoHave

1. Exposure to job scheduling/monitoring environments(Eg. ControlM)

2. Any Big data tools Hadoop Spark.

3. Cloud migration experience

SN

Responsibility of / Expectations from the Role

1

Implementing ETL pipelines within and outside of a data warehouse using Python and Snowflakes Snow SQL

2

Work with the end user to get data requirements performing complex data mapping and developing/maintaining ETL programs to support enterprise data warehouse

3

Develop SQL scripts to load data from source systems and verify the data in target tables load correctly by ELT process

4

Development of scripts using Unix Python etc. for loading extracting and transforming data.

5

Assist with production issues in Data Warehouses like reloading data transformations and translations

6

Develop a Database Design and Reporting Design based on Business Intelligence and Reporting requirements