Sr. ETL Developer

in California(CA)

Position: Sr. ETL Developer

Location: SFO, CA

Duration: 6-12 Months Contract

Job Description:

. Extensive experience in end to end implementation of Comprehensive Capital
Analysis & Review (CCAR) and Intermediate Holding Company (IHC) Applications
to be compliant with Fed CCAR requirements.

. Working experience in implementation of Finance and Risk Mart (FARM) to
provide consistency and conformity across business lines to support IRR,
SCCL Reporting and Credit Risk Model.

. Hands on experience with Data Quality projects such as SOR DQ, Fed EDIT
Checks, and KDE using Informatica Data Quality (IDQ) 9.x and PWC 9.x.

. Experience in Master Data Management projects using Informatica MDM and
PWC along with Oracle.

. Development experience in compliance related data warehousing projects for
Commercial Baking Group (CBG), Regional Banking Group (RBG), Wealth
Management Group (WMG) and National Finance Group (NFG).

. 10+ years of overall IT experience with exposure to the entire SDLC - User
Interaction, Business Analysis/Modeling, Design, Development, Integration,
Planning, testing and documentation - in data warehouse applications, ETL
processing and distributed applications.

. Strong expertise in DWH technologies, ETL designing, mapping development
including Type-I, Type-II, Type-III slowly changing dimensions (SCD) using
Informatica Power Center 8.x/9.x.

. Experienced in using advanced concepts of Informatica like push down
optimization (PDO).

. Working expertise in data model design using Erwin data modeling tool and
good knowledge of Dimensional Data modeling, Star Schema, Snow-Flake Schema,
and FACT and Dimensions tables along with CDM, LDM and PDM building.

. Expertise in writing SQL, PL/SQL program, Stored Procedures, Package,
Functions, Triggers, Views, Materialized Views.

. Expertise in Performance Tuning and Debugging of existing ETL processes or
long running jobs and Oracle SQL Scripts.

. Extensive knowledge of databases like SQL Server, DB2 and Teradata.

. Conceptual knowledge of ETL tools like OWB, SSIS and Ab-initio.

. Hands on experience in writing UNIX shell scripts to process Data
Warehouse jobs.

. Experience coordinating with Business Users, functional Design team and
testing team during different phases of project development and resolving
the issues.

. Knowledge of Cloud based and Digital technologies, Informatica Cloud, MS -
Azure, AWS, Hadoop, Big data.

. Working knowledge in BI tools like SSRS, Cognos, OBIEE, Tableau and BO.

. Excellent written and verbal communication.

Recent jobs at EADJObs.com
Senior Business Analyst in New York(NY) 29-12-2017
SQL DBA :: Lansing in Michigan(MI) 29-12-2017
devloper in California(CA) 08-12-2017
Java developer in Ohio(OH) 08-12-2017

« Go back to category
Recommend to a friend
Published at 08-12-2017
Viewed: 374 times