AWS Data Engineer (Senior) with skills Data Engineering, Python, Microsoft SSRS, Power BI, ETL, Microsoft SSIS, BI & Visualization Development, SQL, AWS DBA for location Gurugram, India
ROLES & RESPONSIBILITIES
Job Purpose:
6+ years of experience
We are seeking a skilled MSBI Developer with a strong foundation in SQL Server to design and implement data engineering and BI solutions. The role requires expertise in SQL Server, stored procedures, AWS Cloud, and Python, along with the ability to create impactful dashboards using Power BI.
Key Responsibilities:
SQL Server Development:
Design, develop, and optimize complex SQL queries, stored procedures, views, and functions.
Build and manage data models and database schemas to support data engineering needs.
Perform query performance tuning and optimization for large datasets.
ETL and Data Integration:
Develop robust ETL processes using SSIS to transform and integrate data from various sources.
Maintain and improve data pipelines for high-volume, low-latency processing.
BI Reporting and Visualization:
Create dynamic dashboards and reports using Power BI and SSRS.
Deliver actionable insights by visualizing data to meet business requirements.
Cloud and Automation:
Deploy and maintain BI solutions on AWS Cloud platforms.
Use Python for automation, data processing, and advanced analytics.
Collaborate with clients to gather and understand requirements, ensuring successful end-to-end project delivery.
Ensure data security, integrity, and compliance throughout the development lifecycle.
Skills & Qualifications:
Primary Skills:
Expert-level proficiency in SQL Server, including query optimization, stored procedures, and database design.
Strong hands-on experience with SSIS, SSRS, and Power BI.
Secondary Skills:
Proficiency in Python for data manipulation and automation.
Experience with AWS Cloud for deploying and managing BI solutions.
Advanced Excel skills for data analysis and reporting.
Desired Background:
Proven track record of delivering SQL Server-focused BI and data engineering solutions.
Experience working with large datasets and implementing end-to-end BI applications.
Strong analytical and problem-solving skills with attention to detail.
Familiarity with cloud-based architectures and modern data engineering tools.
EXPERIENCE
- 6-8 Years
SKILLS
- Primary Skill: Data Engineering
- Sub Skill(s): Data Engineering
- Additional Skill(s): Python, Microsoft SSRS, Power BI, ETL, Microsoft SSIS, BI & Visualization Development, SQL, AWS DBA
ABOUT THE COMPANY
Infogain is a human-centered digital platform and software engineering company based out of Silicon Valley. We engineer business outcomes for Fortune 500 companies and digital natives in the technology, healthcare, insurance, travel, telecom, and retail & CPG industries using technologies such as cloud, microservices, automation, IoT, and artificial intelligence. We accelerate experience-led transformation in the delivery of digital platforms. Infogain is also a Microsoft (NASDAQ: MSFT) Gold Partner and Azure Expert Managed Services Provider (MSP).
Infogain, an Apax Funds portfolio company, has offices in California, Washington, Texas, the UK, the UAE, and Singapore, with delivery centers in Seattle, Houston, Austin, Kraków, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.