ETL Senior Developer
Location: Parsippany, NJ
Duration: 3 months to hire
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 candidate will assist with and is responsible for sound detailed design
Review proposed solutions and guide other resources through an efficient, high performant and secure implementation adhere to industry best practices and standards
Work with Multiple Associate Technical Leads and other Technical 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
Strong hands-on experience in development of large-scale ETL & EDW applications/systems and working within Informatica PowerCenter environments
Experience working on large cross functional projects.
Demonstrated leadership abilities in a team environment
Must be able to communicate effectively and build solid relationships
Excellent analytical, problem solving and technical skills
Good verbal and written communication skills and exceptional interpersonal skills.
Communication skills to clearly articulate and represent engineering team in project and/or solution meetings
Minimum Requirements and Qualifications
Minimum BS in Computer Science/Information Systems or related field and/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 of experience with Informatica ETL
10+ years of Data warehouse and BI experience.
8+ years of architect and lead 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
Strong experience leading multi-site and/or off-shore development teams.
Experience with various software development estimation techniques.
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
Please send resume to:
Informatica, ETL, PowerCenter
3 Months to hire