Pay Range: $43hr - $48hr
- Responsible for designing, developing, enhancing, and supporting ETL solutions using Informatica PowerCenter in a data warehouse environment while collaborating with onshore and offshore teams.
Experience:
- 7+ years of experience in a lead development role within a data warehouse environment.
- 10+ years of experience in development, maintenance, and enhancement of Informatica mappings, workflows, and processes.
- Experience working with complex SQL for ETL development.
- Proven hands-on experience with Informatica integration technologies and processes.
- Experience working in Windows environments.
- Experience with Enterprise Data Warehouse reconciliation solutions.
Responsibilities:
- Develop new ETL processes, complex enhancements, and modify existing code using Informatica PowerCenter.
- Independently develop, configure, and unit test ETL programs based on source-to-target mappings.
- Collaborate with data architects, reporting teams, and application teams on ETL development efforts.
- Design and document ETL solutions for projects.
- Estimate work effort and provide task status updates.
- Coordinate development activities for offshore and onshore Informatica ETL developers.
- Allocate work to ensure high-quality deliverables and support team development.
- Provide technical support for Informatica administration and production support activities.
- Perform level three troubleshooting, operational support, and baseline support.
- Create and maintain ETL development best practices and methodologies.
- Prepare runbooks and production support documentation for developed code.
- Identify and implement improvements to the data warehouse environment.
- Work closely with offshore teams to implement ETL solutions and enhancements.
- Escalate issues appropriately when required.
Should Have:
- Strong analytical, organizational, presentation, and facilitation skills.
- Ability to multitask and work under tight deadlines.
- Strong collaboration and leadership skills for distributed teams.
Skills:
- Informatica PowerCenter.
- ETL development and data integration.
- Complex SQL development.
- Data warehouse methodologies including Kimball, Inmon, and Millbrook.
- Testing tools and techniques.
- Production support and troubleshooting.
- ETL workflow and mapping development.
Qualification And Education:
- Bachelor’s degree in Computer Science, MIS, related field, or equivalent experience.
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading staffing and recruiting powerhouse. Proudly recognized as a nationally and locally certified diversity firm, Cynet delivers agile, scalable talent solutions across industries. With an active footprint in all 50 U.S. states and Canada, we support thousands of consultants through our expansive, high-performing recruitment engine operating across North America and Asia—ensuring speed, quality, and consistency in every hire.