Job Description :
Location: Rosemont, IL
Duration: 1 Year

No. of positions: 2

*Responsibilities:*

- Independently lead large projects from the inception, delivery and
support using the team and other employees as needed.
- Manage as the TL, business analyst, architect, design and UAT
- Design and support high level ETL solutions working with IT/Business
stakeholders
- Design, Develop and Architect ETL code
- Must Have Skills - SSIS, SQL, ETL, SQL Server, Mongo DB, Data Stage
- Work from enterprise roadmap vision to articulate project charter and
high-level requirements and milestones
- Collaborate with business and development teams to gather, document,
and represent data and BI requirements
- Decompose vision and high-level requirements into detailed technical
solutions, processes, metadata, procedures, training, and standards
- 6+ years of experience in Information Management, with a focus on data
warehousing and ETL technologies.
- Experience working with Agile development methodologies

*Qualified Candidates will have*

· Should have worked on SSIS/SSRS 2012 and above
· Work related to ETL process improvement - Configuration of
notification system/automatic alerts
· Work related to ETL Support - Support provided to end users on
day to day issues related to ETL
· Provides design and support in constructing and implementing
advanced ETL framework and supports all integration activities within the
organization.
· Works with leadership on the future state ETL architectural
strategy and road map, while contributing with innovative new solutions.
· Leads initiatives with new solutions, and assists in performance
and scalability planning; assists with testing as required.
· Actively participates in the Governance process associated with
technology and database standards.
· Provides insight and guidance on the development, review and
adoption of integration and database standards and best practices.
· ETL stabilization – Like fixing data synchronization issues
between source system and BI system
· Any ETL performance tuning activities