ETL Programmer Analyst
1yr
Location: Menomonee Falls, WI
Job Summary
•
•Code, test, debug and implement ETL mappings and workflows.
•Interpret written business requirements and technical specifications to create and maintain mapping design document.
•Actively contribute to design reviews.
•Perform quality coding to business and technical specifications.
•Create, document, and implement test plans and scripts.
•Optimize performance of ETL mappings, processes and load routines.
•Participate in design workshops, providing technical insight and knowledge.
•DB analysis to determine health and usage, ETL Benchmarking and workflow workload testing.
•SQL performance tuning, scripting Unix shells and integrating with Workflows.
•Integrating ETL with NoSQL databases using Java and JavaScript frameworks.
•Timely and accurate ETL program development using the SQL Server Information Services or Information Builders iWay product in support of building the Microsoft SQL Server Data Warehouse
•Define and implement ETL design, development and implementation standards and procedures based on industry best practices.
•Work closely with the ETL Developers to ensure adherence of the ETL guidelines, standards and procedures to be applied to all development projects.
•Participate or assist in the translation of user requirements into data flows, detail technical specifications and data mappings.
•Design and develop the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling.
•Assist in operationalizing the ETL production environment
•Assist in oversight and monitoring of ETL production environment
•Adhoc ETL programming in support of development of BI report development
Experience
•The ideal candidate will have proven SSIS or iWay experience working with large data files and understand the components of efficient ETL processes.
•Good knowledge of the SQL Server and Oracle RDBMS environment
•Familiarity with PERL/Unix Scripting and MS Excel (desirable)
•Candidate is expected to work independently, and possess solid project management and prioritization skills.
•IBI WebFOCUS Business Intelligence Tool experience a plus.
•Healthcare Industry experience a plus.
•5 years of solid ETL programming experience
•
Education
•Minimum of a Bachelor's degree or equivalent in Computer Science, Electrical Engineering or in related field.
Special Skills
•SQL Server Information Services (SSIS)
•Information Builders Data Migrator
•IBI iWay
•SQL
•Data Warehousing Concepts
•Work within formal Change Management methodologies.
•Quickly learn new technologies and processes.
•Work on multiple, concurrent projects in a matrixed personnel environment.
•Work well with a variety of teams and organizations to provide responsive and quality support.
•Accept challenges and change.
•Gain the respect and cooperation of others.
•Accept new initiatives and ideas and implement them.
•Share information openly and honestly.
•Listen actively.
•Demonstrated ability to quickly learn new technologies and processes.
•Must be able to work on multiple, concurrent projects in a matrixed personnel environment.
•Customer Focus: Strives to give customers the best. Takes the initiative to add value.
•Must be able to work well with a variety of teams and organizations to provide responsive and quality support.
•Positive Thinking: Energetic and enthusiastic, with a can-do attitude. Deals with issues in a proactive manner.
•Accepts challenges and change.
•Results Orientation: Demonstrated sense of urgency.
•Gains the respect and cooperation of others.
•Accepts new initiatives and ideas and implements them.
•Communication: Verbal and written communications are clear, concise, timely, and understandable.
•Shares information.
•Active listener.
•Proven track record in developing viable options, recommending solutions to address business and technical needs.
•Adapts style and content of communication for technical and non-technical audiences.
•Demonstrated Communication - verbal and written.
•Data modeling.
•Data architecture.
•Data standards in healthcare.
•Enterprise Data Warehouse design and technology options.
•Data migration.
•Business Intelligence tools.
•Teamwork and collaboration.
--
The Most Active and Happening #1 ERP/SAP Jobs Listserve for SAP Jobs in the US.
LIKE our Facebook page : https://www.facebook.com/ERPJobs
https://groups.google.com/group/sapjobs-usa
Follow us on Twitter:
https://twitter.com/sapjobsusa
Post your Jobs at SAP JOBS USA Linkedin Group by clicking this link
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
Join our Professionals Networks in Linkedin
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
https://www.linkedin.com/groups/Global-Network-SAP-Professionals-4081179/about
https://www.linkedin.com/groups/Network-SAP-Professionals-3874920/about
https://www.facebook.com/groups/SAPHCMglobal/
http://finance.groups.yahoo.com/group/SAPJobs-USA/
https://www.facebook.com/groups/sapglobal/
https://www.facebook.com/groups/mysapfico/
---
You received this message because you are subscribed to the Google Groups "SAP JOBS USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to SAPjobs-USA+unsubscribe@googlegroups.com.
To post to this group, send email to SAPjobs-USA@googlegroups.com.
Visit this group at http://groups.google.com/group/SAPjobs-USA.
To view this discussion on the web visit https://groups.google.com/d/msgid/SAPjobs-USA/CAF2bAQ5wrbhYHFCin_dX1%3DL1dK-KFYCfH-SLcWy3mGZhYGwPuw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment