Job Description :
Job Title: Lead ETL Developer
Location: Parsippany, NJ
Duration: 6+ months

Interview Mode: Phone and Face to Face
Need USC or GC only

Summary
The Tech Lead, ETL is responsible for the integrity and data design patterns of Company Hotel Group’s ETL environment.
This role is responsible for oversight through the development of standards, policies, architectural patterns, and frameworks.
This person will be part of a team that leads requirements analysis, data integration architecture, estimation, standards development/enforcement, and ensure alignment and guide the organization towards strategic goals.
This role also requires working with onsite, offshore groups as well as external partners/vendors on a daily basis.
They should maintain strong working technical proficiencies with existing technologies and remain abreast of emerging technologies, at the same time share specific competencies across the Engineering team.
They need to work collaboratively with other teams within IT and across the business teams and partners to achieve project and solution goals.
Responsibilities
The Tech Lead, ETL role is responsible for designing and creating the Extract, Transform and Load jobs for Data Warehouse
Communicate designs and technical requirements with technical teams and lead the technical implementation of the overall system
Represent engineering team in project meetings and solution discussions
Review System requirement documents prepared by strategic partners and ensure business requirements are met from both functional and technical aspects
Guide and lead the creation of the system and detailed technical design. The Technical lead is ultimately responsible for sound detailed design
Investigate new technologies and guide developers to assist in investigation
Review proposed solutions by senior engineers and guide them toward an efficient, high performant and secure implementation adhere to industry best practices and standards
Work with Multiple Associate Tech. leads and other Tech leads across multiple systems to achieve the project goal for a particular project.
Communicate with the project team, support teams and strategic partners effectively to achieve the project and solution goals
Actively Participate in and/or Lead data design sessions
Assist the Software Development Manager with Team building activities – Recruitment, Coaching etc.
Provide status reports
Create / Contribute to project estimates
Accurate and Timely time-tracking
Complexity
This position demands active participation across multiple functions and departments along with working relationships with the various Business and IT divisions as a peer and colleague.
This will require interaction and collaboration with business intelligence users, BI developers and ETL developers.

Competencies
Experience working on large cross functional projects
Demonstrated leadership abilities in a team environment
Ability to work collaboratively and influence the project team to achieve the goals
Ability to work with the team to put together estimations, presentations, risks, and solutions
Ability to work well in a matrix organization leading employees and consultants
Team player who can mentor and guide developers and strategic partners on strategic and tactical application designs
Excellent analytical, problem solving and technical skills
Must be able to communicate effectively and build solid relationships with individuals at all levels, in multiple geographies and business functions.
Good oral and written communication skills and exceptional interpersonal skills.
Ability to manage time and pressures to work on multiple concurrent initiatives
Travel Requirements
Travel requirements for this role will vary based on the business needs and programs lifecycle, estimated to average 5% - 10% of the time; travel possibility within the U.S.

Minimum Requirements and Qualifications
Minimum BS in Computer Science or related field or equivalent experience
Master''s Degree in Computer Science preferred
12+ years of related technical work experience in the implementation of complex, large scale, enterprise wide projects including analysis, design, development and delivery
10+ years’ experience with Informatica ETL
10+ years of Data warehouse and BI experience.
8+ years of architect level experience in Informatica in implementing large scale platforms.
In-depth experience with Informatica PowerCenter / Enterprise PowerCenter Grid.
Informatica Cloud and iPaaS experience is a plus
Must have in-depth knowledge of data best practices
Must have a background and knowledge in enterprise data strategy and/or information architecture
Ability to understand BI Reporting Requirements and warehouse ER diagrams.
Proven record of complex business requirements handling.
Strong Database & Performance Tuning Knowledge
SME for all ETL/Informatica related design and implementations.
Experience in AWS services such as S3, Elastic Beanstalk and Cloud Formation
Experience in AWS managed databases such as Dynamo and Redshift is a plus
Ability to perform data related design reviews and code reviews.
Experience with dimensional modeling using star schema and snowflake models
Experience working in Agile projects
Hotel industry experience a plus
             

Similar Jobs you may be interested in ..