Senior ETL Developer
Apply NowCompany: Cynet Systems
Location: New York, NY 10025
Description:
Job Description:
Pay Range: $55hr - $60hr
Responsibilities:
Pay Range: $55hr - $60hr
Responsibilities:
- Develop new ETL, complex enhancements and modify existing code using Informatica Power Center.
- Work independently to develop, configure, and unit test programs from specs (source to target mappings).
- Work closely with data architects, reporting team and application team on ETL development efforts.
- Design and document ETL solutions for projects, estimate work effort and provide status of tasks.
- Coordinate development work of all Informatica ETL developers which are located offshore and onshore.
- llocate work as needed to ensure high quality for their deliverables and support their development.
- Provide technical support for the administration and production support of Informatica.
- Provide level three troubleshooting, baseline, and operational support.
- Create and maintain best practices and methodologies for ETL development team.
- Prepare runbooks that describe, and support code that is developed, as well as production support.
- Identify improvements to the data warehouse environment.
- Work with the offshore team to implement these solutions.
- Know when to escalate issues to the right party as required.
- 7+ years of experience in a Lead development role for a data warehouse.
- 10+ years of experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
- Experience working with complex SQL for ETL development.
- Proven, hands on experience with development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
- Expertise with integration technologies and processes.
- Excellent analytical, organization, presentation, and facilitation skills; ability to multitask under tight deadlines.
- Working knowledge of Kimball, Inmon, Millbrook design methodology.
- Knowledge of testing tools and techniques.
- Experience within window environment.
- Working knowledge of EDW reconciliation solutions.