Hello,


Hope you are doing great!

Please share resume for below position.



*Role: Data Warehouse Developer*

*Location: Tampa, FL*

*Duration: 9+ Months*



Competencies Oracle EBS HCM R12

Experience (Years)          8-10

Essential Skills • Oracle 11g/12c and its tools ...

• Oracle 11g/12c and its tools SQL and PL/SQL with high performance Data
Warehouse systems

• Hands-on development using Informatica Power Center to create initial ETL
load routines and establish standard and templates

• TOAD, Unix Shell scripts and Tivoli Work Scheduler

• Oracle Data Security implementation experience

• Ensure ETL quality through inspections and knowledge sharing

• Strong analysis and design skills. Strong experience with business
intelligence and data warehousing design principles and industry best
practices.

• Ability to analyze the data from multiple data sources including
PeopleSoft HRMS, Workday, Microsoft Access, SQL Server, SAP R3/ECC and flat
files.

• Data Modeling using ERWIN and/or TOAD data modeler

• Design and development of Slowly Changing Dimensions, transactional
Facts, non-transactional and snapshot FACTs

• Experience in investigating data quality issues to determine root causes,
resolve any data issues and recommend process changes to prevent
reoccurrence.

• Define and implement ETL development standards and procedure

• Ensure effective ETL functional decomposition into deliverable objects

• Ensure ETL quality through inspections and knowledge sharing

• Strong analysis and design skill

• Strong experience with business intelligence and data warehousing design
principles and industry best practices

• Working with offshore team in efficient manner

• Team player with excellent written and verbal communication skills



Role Description:

The HCM Data Warehouse ETL Developer/Designer is a highly technical
position as part of HSC technical development team with the following
responsibilities:

• Collaborates with HSC team managers on requirement analysis and design of
HCM Data Warehouse that sources data from multiple data sources

• Creates technical design documents for database and ETL objects for new
HSC data warehouse

• Responsible for development, validation, publishing, and maintenance of
Data Warehouse and ETLs required to create and maintain HSC Data Warehouse
per technical designs

• Implements the dimensional model “STAR” schema in target data Warehouse,
writing SQL queries, Creates necessary PL/SQL Stored Procedures.

• Designs and develops Informatica Mappings/mallets and workflows and
performance tuning of ETL and database

• Implements data security in HCM Data Warehouse per the business
requirements

• Participates in design and code reviews to make sure the development
standards are implemented











*Satish Kumar* | SYSMIND, LLC
*Technical Recruiter*

Phone: 609-897-9670 x 2152

Email: [email protected]

Gmail: [email protected]

Website: sysmind.com

Address: 38 Washington Road, Princeton Junction, NJ 08550

-- 
You received this message because you are subscribed to the Google Groups 
"Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/android-developers.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/android-developers/CAHxR9GYZqJJqa_cfcWWHA3_-v_t9AdWSwiSJWqGMXWLEkpENAQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to