Dice is the leading career destination for tech experts at every stage of their careers. Our client, Cygnus Professionals, is seeking the following. Apply via Dice today!
Greetings for the day.
We have a position for
Data Engineer Please have a look at the complete job description below and let me know if you have anyone interested.
Job Role: Data Engineer
Location: New York, NY (Hybrid)
Duration: 18+ Months
Visa : Visa Independent
Primary Responsibilities
Must Have Skills: Informatica Power Center, Data Warehouse Multi-Dimensional modelling, SQL and PL/SQL skills.
NOTE FROM HM: The Candidate needs to be strong enough in
Informatica Power center Development and
Data Warehouse Multi-Dimensional modelling along with good
SQL and PL/SQL skills. Please screen candidates thoroughly on these skills.
Job Summary
The Data Engineer is part of a Corporate Analytics team responsible for supporting data and analytics solutions for Client's Corporate Functions. This individual will collaborate with analytics team to design and implement Client corporate data strategy, ensuring reliable data infrastructure and creating data solutions for variety of business use cases. This individual will primarily support on enterprise financial data warehouse and multiple data marts working with various stakeholders and reporting applications team, successfully delivering the data requirement solutions.
MUSTHAVE
8+ years of experience with Oracle and SQL Server databases.
8+ years of experience with Informatica Power Center.
8+ years software development experience in one or more of the following areas: ETL, BI and DW
8+ years of experience in DW Multi-Dimensional modelling.
Understanding of the Project Delivery Framework and SDLC.
Understanding of Waterfall and Agile Project Management Methodology.
NICE TO HAVE
Excellent communication and presentation skills
Domain knowledge in one of more of corporate functions such as HR, Finance, Real Estate is preferred.
Excellent Problem-solving skills with innovative and proactive approach
Ability to recommend and implement best practices and processes.
What you need to have:
- Strong analytical, communication and interpersonal skills.
- Excellent and proven collaboration skills
We will count on you to:
- Designs, develops, automates, and supports complex applications to extract, transform, and load data.
- Ensures data quality of the warehouse and data marts.
- Plans and conducts ETL unit and development tests; monitors result and takes corrective action.
- Work on basic and advanced transformations in informatica power center independently.
- Performance Tuning of SQLs and handles huge volumes of data.
- Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
- Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process.
- Translates transformation and movement requirements into functional requirements and mapping designs.
- Designs automation processes to control data access, transformation, and movement.
- Ensures source data availability and update accessibility, data integrity, restart ability, and error handling.
- Participates in the overall development process via architecture guidance, design and code reviews, and estimation and planning assistance
- Performs other related duties as required Knowledge, Skills, And Abilities
- Documents and troubleshoot problems and effectively communicate with business and technical team members at all levels
What makes you stand out?
Excellent communication and presentation skills
Domain knowledge in one of more of corporate functions such as HR, Finance, Real Estate is preferred.
Excellent Problem-solving skills with innovative and proactive approach
Ability to recommend and implement best practices and processes.
Best Regards,
Ravinder Molugu | Senior US IT Recruiter
T: x Extn: 9055
F:
E:
Data Engineer| New York, NY (Hybrid) /