Sr. BI ETL Developer::ONLY GC, USC

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: 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.