Required Skills

ETL data warehouse

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 30th Jul 2022

JOB DETAIL

The role requires strong collaboration with application development teams, business teams and key stakeholders. This position demands a well-organized, action-oriented team player with exceptional time management and communication skills to simultaneously support multiple initiatives.

 

Role responsibilities:

Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL framework as necessary to connect legacy data stores, the data warehouse, and third-party platforms including Salesforce

·        Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity

·        Ensure the stabilization and high performance of existing ETL processes

·        Troubleshoot any complex data-related issues as well as provide support to production

·        Develop and deploy ETL job workflow with reliable error/exception handling and rollback

·        Drive process improvement and improve process efficiency

·        Document all ETL and data warehouse processes and flows

·        Design data warehouse architecture for future expansion

·        Communicate issues, risks and concerns proactively to management

·        Minimum 5 years of professional experience in ETL development and Microsoft SSIS, SSAS

·        Minimum 5 years of professional experience in T-SQL development, debugging and optimization

·        Experience working in an Agile environment (Scrum, Kanban)

·        Experience with SQL Server Reporting Services (SSRS) and Microsoft Power BI is a plus

Company Information