• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 1st Nov 2023

• Capable of developing Data Warehouse solutions using cloud-based tools in an Azure (primary)

and AWS (secondary) cloud environment

• Develop automated processes using ETL tools such as SSIS and Azure Data Factory

• Analyze data and create sound database designs using dimensional and relational models as

needed

• Experience integrating data processes with various web services technologies (RESTful API,

SOAP, RPC)

• Ability to triage issues and provide 3rd tier technical support in both production and non-

production environments to resolution

• Capable of communicating issues, developing plans and recommendations for corrective

actions to mitigate future recurrences

• Desire to become a subject matter expert in the data and processes utilized to maintain the

platform with a keen eye towards improving

• Design tables, stored procedures, views, and other database objects within SQL Server on prem

and in the cloud

• Advanced SQL-querying proficiency

• Ability to troubleshoot and improve database performance issues including indexing strategies

for various workloads

• Perform unit testing and prepare data and processes for QA/UAT

• Work with team manager to track progress on projects and update tracking systems.

• Experience with Git repositories for source control and CI/CD pipelines

• Collaborate with members of the BI team and operations to understand business requirements

and develop effective solutions.

 

Special Skills

 

• Strong Enterprise Data Warehousing skills and thorough understanding of methodologies

including managing various flavors of slowly changing dimensions

• Understanding of ETL Frameworks, utilization of templates, design patterns and metadata to

build supportable data integration processes.

• Proven experience using Cloud based technologies, especially regarding ELT software or other similar tools

• Must be well organized and able to clearly and concisely present documentation of issues and

potential resolutions to technical and non-technical teams

• Enthusiasm for exploring new technologies - with an eye on maintainability

• Desire to deliver high quality customer service

• Ability to adhere to organizational and departmental policies and goals

• Excellent problem solving and interpersonal skills

• Demonstrate the strong written and verbal communication skills required in a disparate work

environment

 

Required Education and Experience

 

• Bachelor’s degree in Computer Science or similar discipline or equivalent work experience

• Experience executing in an Agile environment

• Demonstrated expertise delivering technical solutions as per tickets, specified plans and

deliverables

• Experience developing Data Lakes / Data Warehouses

• Exposure to data streaming technologies and methods, ESB, pub/sub models

Preferred Education and Experience

• At least 10-12 years of experience

• 2+ years’ experience with cloud computing (AWS, Microsoft Azure, Python)

• Strong automation and programming skills experience

• Demonstrated knowledge of various scripting tools