• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 23rd Jan 2021

Mandatory : USC & GC - Local to PA 

Responsibilities:

Engineer and deliver end to and data solutions to meet a wide range of business requirements using Informatica PowerCenter Administer, troubleshoot and provide developer support for the Informatica PowerCenter and Denodo environments Develop LINUX and Python scripts to enhance Informatica's ETL capabilities and shortcomings Work with business analysts to acquire and analyze data to meet their business needs Investigate data issues by tracing data flows from source to target systems and writing SQL Performance tune ETL workflows, scripts and SQL written by other team members and business users Support weekly and monthly data load processes, investigate and bring issues to resolution Be an active member of our Agile team and processes, participating in all ceremonies and continuous improvement activities Embrace learning, innovation and disruption in a continually changing world where new technologies and techniques are introduced on a continual basis

Qualifications:

Experience creating Informatica workflows and associated components

Experience creating tables and views in an SQL SERVER database

Experience writing and tuning complex SQL queries

Experience in designing data models (star and snowflake schemas)

Experience in writing LINUX shell scripts In depth understanding of data warehousing, ETL concept, data loading strategies, data archiving, and ETL error handling Basic knowledge of how Finance or capital markets,  a plus