Job Description :
Hi,
Role: Senior ETL Developer (Microsoft Stack- SSIS, SSRS, SSAS)
Location: Richmond, VA
Duration: 6+ Months
Interview: Phone and F2F
Visa: USC/GC/EAD-GC with good communication skill
Responsibilities:
Designs and develops ETL solutions using data warehouse design best practices and SQL Server Integration Services (SSIS
Analyze data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration projects.
Analyze business requirements and outline solutions.
Provide technical assistance in identifying, evaluating, and developing systems and procedures.
Document all ETL and data warehouse processes and flows.
Create or update technical documentation for transition to support teams.
Develop automated data audit and validation processes.
Develop and deploy ETL job workflow with reliable error/exception handling and rollback.
Manage data stage administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows.
Adapt ETL code to accommodate changes in source data and new business requirements.
Provides senior technical leadership to design, architecture, integration and support of Managed File Transfer platform with a focus on high availability, performance, scalability and maintainability
Manage automation of file processing as well as all ETL processes within a job workflow.
Contribute and adhere to the development of standards and sound procedural practices.
Lead ETL design and review meetings.
Perform and coordinate unit and system integration testing.
Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications.
Ensure data quality throughout entire ETL process, including audits and feedback loops to sources of truth.
Knowledge & Skills:
Creative problem solver with excellent communication, leadership and collaboration skills.
Advanced decision making and problem solving skills
Business acumen, knowledge and professionalism
Proactive leadership style and a self-starter and strong attention to detail
A clear and familiar understanding of the concepts and best practices of data warehouse ETL design
Demonstrated expertise around the Microsoft SQL Server technologies (primarily SSIS
Methodical and structured approach to design and development.
Delivery focused with the ability to prioritize activities.
Flexible team player within a small, multi-disciplinary team.
Qualifications
A Bachelor’s Degree in a technology area of study; preferably in Computer Science, MIS or Analytics.
5+ years of previous experience supporting data warehouse implementations
3+ years ETL development experience using Microsoft SQL Server Data Tools/BIDS, with deep and thorough hands-on use of SSIS.
5+ years of experience in relational and data warehouse database design, optimization and performance with MS SQL.
3 + years of experience with Secure File Transfer Protocol (SFTP) tools, standards and processes between client and server on a computer network.
3+ years in a structured IT organization with a strong PMO, a variety of methodologies, and strong technical environment management.
7+ years equivalent work experience in Information Technology.
Knowledge of ETL and data warehouse concepts with Data Vault 2.0 methodology preferred.
Experience with multiple SDLC methodologies – Waterfall and Agile.
Extensive experience with data dictionaries, data analysis and relational databases.
· Proven understanding of SQL optimization (indexing and ability to interpret and act on execution plans
Sunil
Sr. Recruiter
?Office Ext 201
Direct
MavTech Solutions