Job Description :

Hyatt Hotels

ETL/Data Engineer

REMOTE in CST

6-MONTHS+

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.

Required Knowledge & Experience:

  • 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.

Preferred Experience:
- Hands-on experience building complex business logics and ETL workflows using Informatica IICS and PowerCenter.
- Good Proficient in SQL, PL/SQL and preferably experience in Snowflake
- Good Experience in one of the scripting languages: Python or Unix Scripting
- -Experience in data cleansing, data validation and data wrangling

Bonus
-Hands-on experience in AWS cloud and AWS native technologies such as Glue, Lambda, Kinesis, Lake Formation, S3, Redshift
- Experience using Spark EMR, RDS, EC2, Athena, API capabilities, CloudWatch, CloudTrail is a plus


Required Skills : ETL, Informatica, Snowflake, SQL
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :VMS Access Entry
Branch Code :Chicago
             

Similar Jobs you may be interested in ..