Job Description :
Must have:
1. Senior SSIS developer with at least 8 years’ experience.
2. Healthcare domain experience.
3. Production Support experience.
4. Extensive experience gathering requirements, designing, and developing data warehouses.
5. Experience with SQL Server (Microsoft
6. Experience in creating packages to extract data from Excel, Flat file, Oracle, DB2, Sybase to MS SQL Server by using MS SQL Server DTS and SSIS
7. Experience with ETL development.
8. Extensive experience in TSQL Development which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and User Defined Functions
9. Extensive experience in performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.

Details:
Lead end-to-end S projects from initiation through closure; including:
Develop detailed project plans and schedules using MS Project
Establish and prioritize project goals/objectives and deliver against them
Deliver status presentations and reports to BCBSM management team articulating project issues, risks, recommended actions
Oversee cross-functional team members in the execution of project related activities in adherence with project budget and schedule
Seeking a self-motivated, technical, results-oriented, and quality-focused individual with data warehouse skills.
Provide overall direction, guidance, and definition of an enterprise data architecture that effectively supports Business Intelligence capabilities. The candidate must have extensive knowledge of data architectures related to Data Warehouse implementations (as compared to OLTP
Ability to thrive in a fast paced environment with multiple ongoing projects concurrently.
Extensive experience gathering requirements, designing, and developing data warehouses.
Experience with SQL Server (Microsoft
Senior SSIS developer with at least 8 year experience. Healthcare industry experience is an asset.
Experience in creating packages to extract data from Excel, Flat file, Oracle, DB2, Sybase to MS SQL Server by using MS SQL Server DTS and SSIS.
Experience with ETL development.
Extensive experience in TSQL Development which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and User Defined Functions.
Extensive experience in performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
Experience with Data Profiling Tools.
Experience with Data Modeling concepts.
Experience with providing End User Query Support.
Proactive, great attention to detail, results-oriented problem solver.
Ability to support long term goals along with immediate performance concerns.
Strong communication skills and ability to translate highly complex technical issues to non-technical audience.
Excellent communication, mentoring and problem solving skills.
Ensure that the designs are consistent with the overall architecture for Business Intelligence as previously documented.
Ensure that significant design decisions are communicated, validated, and adhered to.
Provide rationale for design decisions.
             

Similar Jobs you may be interested in ..