Sr. BI ETL Developer
LENGTH OF CONTRACT: 6 months
LOCATION: Pittsburgh, PA (Southside)
CITIZENSHIP: U.S. Citizen or Green Card Only
Job Title: ETL Developer, Business Intelligence, Consultant
KEY ACCOUNTABILITIES
Develop ETL processes
Ensure strategies align or recommend improvements
Unit test solutions
Raise issues and suggest resolutions
Suggest Data Mart table/indexing improvements
Create migration plan
Maintain change log and distribute to team
Create ETL documentation
MUST HAVE: Experience developing ETL processes and generating SQL procedures and validation scripts
EXPERIENCE: 4+ years
KNOWLEDGE/EXPERIENCE/COMPETENCIES
Education – Bachelor's degree; Masters preferred
Experience – minimum of 5 years of professional experience in similar role
Competencies –
Translate the strategies used in implementing requirements to ETL code, ensure that it is a high performance solution and execute them.
Work in collaboration with the Data modeler and Technical BI BA.
Experience with SQL in order to generate SQL procedures and validation scripts.
Responsible for creating and updating industry/ SDLC specific ETL best practices document. Templates for standardized SQL aliasing and ETL documentation should be used.
Create and execute the overall unit testing plan. Ensure the usage of standard template and follow best practices.
Responsible for sharing any issues or potential road-blockers during the project. Be a part of the team meetings and share the issues and suggest solutions.
Suggest indexing/partioning strategies to the Architect/Data Modeler based on ETL process requirements.
Log all ETL scripts/maps and execution instructions in ETL Change Log. Incorporate complete instructions into an ETL migration plan.
Work with Data Modeler to identify all DM and ETL components required for migration.
Work with Architect to devise schedule and timings.
Log all ETL updates on the Change Log and keep the team in loop.
Ensure to re-visit this document before every migration.
Ensure that all the ETL documents like Process Flows, Logic Presentations, etc. are up-to-date and are reviewed by the Architect before being shared with the client / stakeholder.
Additional Qualifications –
Clear and professional written and verbal communications skills with presentation and facilitation skills
Demonstrated professional interpersonal skills
Demonstrated leadership experience in a project team
Collaborative professional style
Client communication experience in a consulting role is a plus
Shweta Ojha
Sr. Technical Recruiter | Sage Group Consulting
Direct: 732-784-6492
Email: sojha@sagetl.com
Gtalk: sojha1290|Ymail: ojha1290
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at http://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment