• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 30th Jul 2022

Role

Sr Data Warehouse Developer

Mandatory Technical Skills

•           Design robust Logical Data Models and stewarding the data design of the asset and ensuring alignment with the larger roadmap goals.

•           Work closely with business users to determine business requirements, lead requirements gathering meetings, propose future enhancements, resolve user queries or any issues.

•           Develop and define application scope and objectives. Prepare specifications for development of data pipelines for migrating data in both OLTP and Data Warehouse environments.

•           Design, develop, debug, and support complex data integration interfaces and processes (including stored procedure and complex queries) using various tools and technologies including Pentaho/SSIS/Informatica, PowerBI, SQL, and PostgreSQL/SQL Server.

•           Create database tables, procedures, views, functions, indexes using SQL programming.

•           Impact analysis on upstream data/process changes to Data Warehouse and Reporting systems.

•           Design database objects as necessary to meet new business requirements for reporting.

•           Conduct technical design and code reviews.

•           Establish, enhance, implement, enforce, and maintain ETL best practices. Own the change request process and coordinate with other teams as necessary.

Desirable Technical Skills

•           10+ years of experience in Business Intelligence, Data Warehousing, SQL, and Data Modeling.

•           Strong understanding of ETL processes, OLAP concepts, SQL programming, and Reporting.

•           Expertise in ETL (SSIS/Pentaho Data Integration/Informatica) and DBMS (SQL Server/PostgreSQL).

•           Experience in SQL Server Reporting Services (SSRS), PowerBI or Tableau.

•           Expert skills in performance tuning, monitoring, and troubleshooting data integration solutions; solid communication, interpersonal, leadership, and collaborative skills and a demonstrated ability for creative problem solving.

•           Experience in Microsoft Azure (Azure Data Factory, Azure Data Lake), and Databricks. Experience in migrating on-premises data/process to Microsoft Azure using Azure Data Factory.

•           Good problem solving and debugging skills.

•           Excellent familiarity with project lifecycle approaches phases and tools.

•           Create and maintain documentation.

•           Strong verbal and written communication skills.