Sr ETL Tech Lead (data warehousing) (Job Code : J44035)  

 Job Summary
Share this job on Facebook  Share this job on Twitter  Share this job on Linked In
 
Experience:
10.00 - 15.00  Years 
 
Location:
Hyderabad
 
Designation:
Sr ETL Tech Lead (data warehousing)
 
Degree:
BE-Comp/IT, BE-Other, BTech-Comp/IT, BTech-Other, MCA
 
Educational Level:
Graduate/Bachelors
 
Stream of Study:
Computer Science/IT
 
Industrial Type:
IT-Software/Software Services
 
Functional Area:
IT Software - Client Server
 
Key Skills:
Azure DFT, RDBMS, Database design, ERD analysis
 
Job Post Date:
2021-06-22 21:53:49  
 
 

 Company Description
 
Our client is a custom-software development company having its headquarters in Minnetonka, MN, and branch offices in Canada and India. Backed by a proven track record of success,Our client has over 140+ customers across the world. We use Agile-methodology to run all our projects from sales, marketing, HR, development, and deployment.

The mission to provide value added software services to our customers was started in the year 2010 with a vision to influence businesses with technology like never before. The founder, spotted the challenges businesses were facing in this increasingly-dynamic business ecosystem. Enticed to eliminate the survival threats to the organization and help them become productive,

Any mission that our team sets out whether it is inter-organizational or intra-organization – is achieved keeping in certain inclusive values. This is not merely a mandate for our client community to follow but also an integral part of our vision. These values hone up each teammate both in a personal and professional manner and they are driven to give out their best:

EINHEIT/ Unity : Our teammates are trained to sync up their personal goals with the organizational goals. With the sense of unity and collaboration instilled in our work style, we confidently promise quality products and services to our clients.

FRANC/ Open : The BPK Tech community has a set of principles, but more importantly, our team is open to new ideas, innovation, and school of thought.

KAIZEN/ Advancement : No bar is the bar! We work to improve every day, bit by bit. That ensures we run with time and stay relevant in our services and products.

RENXING/ Humanity : Each member of our team understands the factors related to humankind very well which helps us serve our customers and clients with zeal and best intentions.
 

 Job Description
 
Sr ETL Tech Lead (data warehousing)
As the Data Architect Lead Engineer, you will be primarily responsible for developing the full life cycle of a Enterprise Data solution (data movement and visualization), including requirements analysis, platform selection, technical architecture design, application design and development, testing, and Test and Deployment in a Cloud based environment. The position will focus on building out a consumer insights strategy and building advanced analytics to deliver capabilities against that strategy using industry best practices meeting functional, non-functional and performance related requirements.
The position requires to develop DFTs, Pipelines, datasets, deployment, execution, monitoring and support the data flow from source to target.
The position requires to review the work of team and guide team in developing of code with best possible standards.
Experience using advanced software and system design skills in an environment using Microsoft Azure (Azure SQL Managed Instance, Data Factory, Azure Monitoring, Azure DevOps, Event Hubs, Azure AD Security, Azure Virtual Machines, Azure Monitoring/Log Analytics).
6+ years of experience with data warehouse technical architectures, ETL/ ELT, reporting/analytic tools and scripting.
Experience in MS SQL Server DB.
Experience writing complex SQL queries (to clean and transform data)
Demonstrated excellent written/oral communication skills, technical documentation skills, user liaison skills, and personal interaction abilities
As the Data Architect Lead Engineer, you will be primarily responsible for developing the full life cycle of a Enterprise Data solution (data movement and visualization), including requirements analysis, platform selection, technical architecture design, application design and development, testing, and Test and Deployment in a Cloud based environment. The position will focus on building out a consumer insights strategy and building advanced analytics to deliver capabilities against that strategy using industry best practices meeting functional, non-functional and performance related requirements.
The position requires to develop DFTs, Pipelines, datasets, deployment, execution, monitoring and support the data flow from source to target.
The position requires to review the work of team and guide team in developing of code with best possible standards.
Experience using advanced software and system design skills in an environment using Microsoft Azure (Azure SQL Managed Instance, Data Factory, Azure Monitoring, Azure DevOps, Event Hubs, Azure AD Security, Azure Virtual Machines, Azure Monitoring/Log Analytics).
6+ years of experience with data warehouse technical architectures, ETL/ ELT, reporting/analytic tools and scripting.
Experience in MS SQL Server DB.
Experience writing complex SQL queries (to clean and transform data)
Demonstrated excellent written/oral communication skills, technical documentation skills, user liaison skills, and personal interaction abilities
Key Skill
Azure DFT, RDBMS, Database design, ERD analysis, ETL, Data warehousing