0
applicants
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.
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

Published at 08-12-2017
Viewed: 211 times
Viewed: 211 times