Informatica Developer

Title: Informatica Developer

Client/domain: Hyatt Hotels

Duration: 6+ months

Description

The Senior Data Engineer will design, code, test, and analyze software programs and applications. This includes researching, designing, documenting, and modifying software specifications throughout the production lifecycle. This role will also analyze and amend software errors in a timely and accurate fashion and provide status reports where required. The position responsibilities outlined below are not all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.

Responsibilities:
Work with Product team to determine requirements and propose approaches to address users' needs
Analyze requirements to determine approach/proposed solution
Design and Build Solutions using relevant programming languages
Thoroughly test solutions using relevant approaches and tools
Conduct research into software-related issues and products
Bring out-of-box thinking and solutions to address challenging issues
Effectively prioritize and execute tasks in a fast-paced environment
Work both independently and in a team-oriented, collaborative environment
Flexible and adaptable to learning and understanding new technologies
Highly self-motivated and directed
Demonstrate a commitment to Hyatt core values

Experience and Skills:
Must have skills:
Strong verbal and written communication skills
Demonstrate integrity and maturity, and a constructive approach to challenges
Demonstrate analytical and problem-solving skills, particularly those that apply to Data Warehouse and Big Data environments
Open minded, solution oriented and a very good team player
Hands on experience in developing Data Lake and Data Warehouse and Data Marts
Proficiency in SQL and Scripting (Unix sell scripts, Python)
Hands on experience in data pipeline development using modern ETL tools specifically on Informatica PowerCenter, Informatica IICS
Hands on experience in trouble shooting complex ETL and SQL problems
Hands on experience in designing and building data pipelines in AWS cloud using S3, Lambda, API Gateway, RDS, Redshift, etc.

Good to have Skills:
Experience in industry standard ETL/ELT tools
Hands on experience with AWS cloud architecture and development using AWS resources like S3, Lambda, API Gateway, RDS, etc
Proficiency in relational databases (Snowflake, DB2, Redshift, etc), database concepts and dimensional modeling
Experience in data cleansing, data validation and data wrangling