*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 *Thanks and Regards* *Shweta Ojha* Sr. Technical Recruiter | Sage Group Consulting *Direct: *732-784-6492 *Email: *[email protected] *Gtalk: *sojha1290*|Ymail: *ojha1290 -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.
