ETL developer

Desired Competencies (Technical/Behavioral Competency)

MustHave

IBM Datastage / Informatica Snowflake SQL Unix

GoodtoHave

DBT

Responsibility of / Expectations from the Role

1

Analyze and build ETL data assets using IBM Datastage / Informatica and OnPrem Databases such as Netezza. Propose design and implement solutions to migrate such data assets to cloud data warehouses such as AWS S3 Snowflake and built ELT transformations using DBT and Python

2

Create and manage data pipelines supporting CI/CD.

3

Work with project and business analyst leads in order to develop and clarify indepth technical requirements including logical and physical data modeling activities

4

Develop test enhance debug and support data assets / applications for business units or supporting functions using IBM Infosphere Data Stage ETL tool suite both ETL and ELT approaches. These application program solutions may involve diverse development platforms software hardware technologies and tools

5

Participates in the design development and implementation of complex applications often using IBM Infosphere Information Server (IIS) products like Data Stage Quality Stage on a Linux Grid environment. Snowflake ControlM/Scheduling tools.