Interview: Phone and F2F
Client is Hyatt
Responsibilities:
Works closely with Hyatt Analytics and Marketing users to understand informational needs and business challenges, document those requirements, and translate into solutions.
Partners with the work stream leads to ensure overall cost, delivery, and quality targets are met.
Reviews functional and business specifications from the team and defines detailed ETL technical specifications.
Utilizes the ETL application to analyze data, necessary to resolve issues uncovered and related to source data, ensuring technical specifications are thorough.
Defines, develops, documents and maintains Informatica ETL mappings and scripts.
Creates and deploys Informatica work flows in Linux environments.
Defines, develops, documents and maintains procedural and SQL programs.
Assists in the development, execution, and documentation of system and integration test plans. Performs ETL / Informatica tuning and SQL tuning.
Optimizes Informatica code performance and processing methods.
Performs design validation, reconciliation and error handling in load and extract processes (initial and incremental).
Support Production batch environment.
Qualifications:
3+ years of Informatica Power Center software experience is REQUIRED.
Strong SQL Knowledge is REQUIRED.
Strong understanding of using ETL tools to integrate systems.
Knowledge of System Development Life Cycle (SDLC).
3+ years working with DB2 or equivalent RDBMS is preferred.
Informatica Power Center 9.6 experience preferred.
Java development experience preferred. Shell scripting experience preferred.
Autosys experience preferred.
•
Last updated on Jun 1, 2016