Job Description :
Hi,

please go through below requirement. If he/she your consultant is comfortable please share his/her updated resume to

Requirement 1:
Position: ETL Developer
Location: San Ramon or Phoenix, AZ
Duration: 1 Year.

Job Responsibilities:
Working on ETL development for the projects/BAU by following standards & best practices, and proactively coordinating/working closely with QA/Analysts/PMs/Delivery Managers/Business on daily basis
Coordinates with business analyst /business owners on reviewing business and technical requirements documents.
Coordinate/Manage development and testing tasks and ensuring adherence to agreed timelines and communicating status
Help and coordinate with team on the industry standards and best practices for effective use of Informatica data integration and data quality technologies and exception handling
Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members
Ensure transition to production support is facilitated in an organized and planned manner

Skills:
Strong technical knowledge in Informatica Power Center, Informatica Data Quality and Metadata Manager
Strong Oracle Database technical knowledge in the areas of general SQL
Thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies
Performance tuning and end-to-end lifecycle experience with Enterprise wide data quality solutions
7-10+ years of experience at Enterprise-level implementation of data Warehouse, regulatory projects and MDM using Informatica PowerCenter, Informatica Metadata Manager and IDQ
5+ years in banking and financial services is preferred
5+ years of experience deploying large scale projects using Informatica Tools
Previous experience around Data Warehouse, regulatory projects, data quality control, MDM and Fraud Monitoring projects is preferred and great value addition
Excellent written and verbal communication
Experience in handling multiple projects, cross functional team and off shore teams

Education/Experience:
Master’s or Bachelor’s Degree in Systems Analysis, Computer Science, Software Engineering, Information Systems, Financial systems and accounting or equivalent combination of education and experience required

Requirement 2:
Position: ETL Developer
Location: San Ramon or Phoenix, AZ
Duration: 1 Yr

Position Details:
ETL Developers: (Multiple Positions)
7 - 10 years of overall IT experience with exposure to the entire SDLC - User Interaction, Business Analysis, 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.
Expertise in writing SQL, PL/SQL program in Oracle database.
Expertise in Performance Tuning and Debugging of existing ETL processes or long running jobs and Oracle SQL Scripts.
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.
Working knowledge in BI tools like OBIEE, Tableau and BO.
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.
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.
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.
Excellent written and verbal communication.

Requirement 3:
Position: ETL Developer
Location: San Ramon or Phoenix, AZ
Duration: 1 Year.

Position Details:
Sr. ETL Developers: Multiple Positions
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.

Please provide me below details
Consultant Full Name:
Work Authorization:
Location:
Contact Number:
Email ID:
Last Four Digits of SSN:
Current Project Ending:
Availability for New Project:
Relocation(Reasons):
(M-F)/NO WORK FROM HOME: Yes
Education / Place / Year:
LinkedIn(Yes/No):
Skype Id:
Availability for Screening:
Total IT Experience:
Preferred skills:
Domain Experiences:
complete Education(India/USA):

Regards!
Anand P
Sr.Technical Recruiter
Promatrix Corp
825 Georges Road, Suite 4
North Brunswick, NJ 08902
Phone No Ext 112
Email:


Client : Capgemini/Bank of the West