Job Description :
Job Description:
Client: E n Y(Ernst & Young)
Position: Hybrid
Location: Alpharetta, GA,.
The ETL developer/application engineer will work as part of the project team. Will be primarily responsible for
implementing ETL processes using SSIS, to populate variety of source data into the Marketing database(s).The
candidate will have a deep understanding of both OLTP and star schemas, with all associated ETL constructs to
effectively manage facts and dimensions. The resulting ETL processes should be scalable, efficient, audited and
as re-usable as possible. This role should also be able to assess data quality and auditability of the overall
flow.
Primary Responsibilities
Develop, design, tune and maintain SSIS packages to perform the ETL process.
Design and develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL
process.
Write scripts for automated testing of data in the target facts and dimensions.
Capture audit information during all phases of the ETL process.
Should have 3+ years technical lead experience .
Write and maintain documentation of the ETL processes via process flow diagrams.
Collaborate with business users, support team members, and other developers throughout the
organization to help everyone understand issues that affect the data warehouse.
Secondary Responsibilities
Design, build and deploy reports in SQL Server Reporting Services (SSRS).
should be good in SSAS and MDX
Skills and Experience
8-10 years of experience using Microsoft SQL Server Database, SSIS , SSRS,SSAS is
required with the development of database/data warehouse/data mart solutions
8+ Years of Strong SSIS 2016 and SQL 2016 Development & support experience.
Solid understanding of the software development process, including requirement
gathering, analysis/design, development tools/technologies,
Collaborate with other teams within the organization and be able to devise the
technical solution as it relates to the business & technical requirements
Will be expected to mentor colleagues and be proactive in developing colleague skill
.
Must be flexible to new situations and challenges
Good time management skills
Problem solving skills are required.
Candidate should be willing to work on extended overlap hours and weekends based
on the client's needs
Strong Communication Skills
             

Similar Jobs you may be interested in ..