Urgentt Need for Senior Informatica/ETL Developer in New York, NY

Please send resume to Martin@catstaffing-us.com
\
Title : Senior Informatica/ETL Developer
Location : New York, NY
Duration : 1+ year Contract

 

Assignment Details
Work on a team that is implementing a BI Solution.

 

Must Have overall 9-10+ Years

This role entails the following:
Analyze, Design & Develop Informatica ETL workflows and mappings that extend BI Apps 7.9.6.3+
Analyze, Design & Develop Oracle DAC workflows
Work with the Data Architect and BI Developers to:
Design & Develop BI Physical Data Model
Determine whether calculations and processing should be done in BI application or the ETL process
Determine requirements for aggregate tables, hierarchies, level based measures, etc.
Move data into the data warehouse for report unit testing

 

Skills & Requirements
Experience with business requirement gathering and analysis
Experience with Data Warehousing Modeling concepts
Experience with creating / maintaining Informatica ETL workflows and mappings
Design and development of ETL programs for creating all data warehouse tables, to support initial load, refresh and on-going update strategies
Experience with maintaining and troubleshooting Oracle DAC workflows.
Understanding of Oracle E-Business Suite/Hyperion source system data models
Work with the project manager, architects, and other team members to define metrics and performance goals for the application
Participate in transitioning the requirements and use cases to the designers, and ensure a clear and complete understanding of the requirements
Assist in translating requirements and use cases into test conditions and expected results for product, performance, and user acceptance testing
Provide guidance on RDBMS system configuration and performance tuning including tuning on detailed, base aggregate and additional aggregate fact and dimension tables
Suggest index strategies and other adjustments to optimize performance
Years of Experience with Informatica: 3 years
Knowledge of Oracle Business Intelligence Applications 7.9.6.3 and 7.9.6.4 a plus

 

---------------------------------------------------
Thanks and Regards
Martin Lee ||| Sr.Technical Recruiter
CAT Technology Inc.
Hackensack, NJ 07601
Direct :- 201-257-5081 EXT:- 326 ||| Fax:- 201-342-2385
Official: Martin@catstaffing-us.com
www.catamerica.com | www.cattechnologies.com
"Committed to Human Excellence -Thru IT"

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at https://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.