| Location | Herndon, VA |
SyApps is a Technology and Management Consulting Services firm based in Greater Washington area, with focus on solutions in the area of Strategy, Process, Technology and Management support. As a diverse end-to end IT and Management solution Provider, SyApps offers a range of expertise aimed at helping customers re-engineer and re-invent their business to compete successfully in an ever-changing marketplace.
Please visit us at www.syapps.com.
Job Description Responsibilities:
Informatica ETL Developer
Provides technical direction in the maintenance and development of the extract transform and load (ETL) aspects of the data warehouse. Maintains an understanding of the inputs received from the data source providers. Performs analysis, design, development, and implementation of new ETL requirements. Recommends changes to enhance the data warehouse data cleansing, and conversion processes. Supports testing and validation of the new data conversion processes. Responsible for planning, and monitoring schedule milestone and deliverables for assignments. Possesses strong SDLC experience and manages appropriate levels of systems documentation as required.
Required Skills
8 years of Experience with Informatica Powercenter
8 years of Experience with Informatica Data Quality
4 Years of Experience with Informatica Power Exchange (change data capture)
Design, Develop, Test, Implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment
Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment
Strong experience optimizing Informatica mappings, sessions and workflows
Experienced writing complex SQL’s, PL/SQL and Performance tuning is a plus
Strong database experience, data analysis and analytical skills
Experience creating ETL design documentation and maintaining overall design document and deliverables
Strong working experience with XML Data
Strong written and oral communication skills
Good understanding of dimensional modeling and ETL designs for loading Star Schemas
Location: Herndon, VA
Travel: No
SyApps LLC is a Winner of the SmartCEO/Grant Thornton Future 50 Award for being recognized as one of 50 fastest growing companies in the Greater Washington Area.
We are proud of our diverse environment, Equal Opportunity Employer. SyApps is committed to a policy of equal employment opportunity. SyApps participates in E-Verify.