• Citizen

• Full Time

• Direct Hire

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 2nd Aug 2022

Competencies/Skills: Individual Contributor Competencies

Knowledge:

Strong knowledge of ETL concepts especially as applied to Informatica, Informatica cloud & SSIS.

Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation &metadata management.

Strong knowledge of data design for various applications.

Strong knowledge of SQL.

Good knowledge of various RDBMS, Mainframe

Good knowledge of Project Life Cycles methodologies.

Strong verbal & written communication skills.

Strong knowledge of Unix & Unix Shell scripting

Experience with Control M, Informatica, Unix, Scripting languages (PySpark / HIVE), Big data knowledge is preferred, SQL, Data warehouse concepts

Job responsibilities:

Provide Production Support, on call support for all 4 ETL platform.

Review & understand business data related ETL requirements for database, application and reporting projects.

Develop & make enhancement on new & existing data systems.

Participate in the development plans & resource estimation for task planning.

Assist with the development of logical data models.

Monitor production jobs & resolve any issues in a timely manner.

Partner with other IT areas in resolving issues & improving processes

Develop Informatica or SSIS ETL Workflows.

Develop ETL code both in Informatica & at the shell script level.