• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 17th Apr 2021

This role will support Archer Data integration in TTDW to support BCP reporting for ‘BCP Operational Data Store’ Project. This resource will design and develop ETL solutions using Microsoft Business Intelligence (BI) tools (SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).

Day-to-Day
 

·         Participate in all phases of the software development life cycle (SDLC), including requirements, technical design, development, testing and implementation

·         Design and develop or modify ETL solutions using MS BI tools

·         Develop, enhance and troubleshoot database objects such as stored procedures, functions, tables and views

·         Design and develop SSAS cubes and data marts

·         Apply generally accepted programming standards and techniques to assure efficient program logic and data manipulation

·         Create and maintain data dictionaries, data model and change management documentation

·         Conduct data profiling to understand data relationship and the quality of data

·         Investigate and resolve data issues as needed

·         Participate in unit testing and troubleshooting

Required Skills
 

·         6 years or more experience in data warehouse design and development using Microsoft SQL Server (2012+) BI stack: SQL server, T-SQL, SSIS, SSAS, DAX

·         Must have 3-5 years of experience developing ETL solution using SSIS

·         Minimum 2 years of experience developing SSAS/Tabular cubes

·         Experience with relational and multi-dimensional databases

·         Experience in using script and Web API in ETL Programs (SSIS packages)

·         Knowledge of source control tools (GitHub, TFS)

·         Ability to work independently and in a team environment

·         Ability to convey complex subject matter clearly

·         Skill in organizing and prioritizing of work, and following assignments through to completion

·         Good problem solving and debugging skills

·         4-year Bachelor's degree in Computer Science or related IT field

Top 3 Skills
 

·         Must have 3-5 years of experience developing ETL solution using MS SSIS

·         Experience in using script and API in ETL Programs using VB.NET and C#

·         Experience in data warehouse design and development using Microsoft SQL Server (2012+) BI stack