SSIS and Azure Data Engineer
Skills
About the role
This role is for one of our clients
Industry: IT Services and IT Consulting
Seniority level: Mid-Senior level
Min Experience: 5+ years
Location: Bengaluru, Pune, Hyderabad
JobType: full-time
Primary Duties and Responsibilities:
Over 5 years of experience in SQL Server ETL development utilizing SSIS, Azure Data Factory, and Azure Databricks, with strong expertise in ETL, data warehousing, and T-SQL.
Comprehensive understanding of data warehouse and data mart architectures, including the Kimball methodology.
More than 5 years of practical experience in building large-scale databases.
Designing, developing, and deploying efficient and reliable data pipelines for data movement and transformation.
Wide-ranging knowledge and hands-on experience in data modeling, data management, ETL, and business intelligence (BI).
Expertise in building enterprise data warehouses incorporating table partitioning, encryption, and data compression techniques.
Experience with cloud migration initiatives.
Conduct ongoing monitoring, automation, and optimization of reports and BI solutions.
Collaborate with BI management to identify and resolve data-related challenges.
Partner with business units to define and document requirements for new metrics and reports.
Participate in process evaluations and improvements.
Provide analysis and resolve issues reported by business stakeholders.
Engage in the design and delivery of cubes, dashboards, and a variety of self-service BI solutions.
Other:
Ensure adherence to established documentation standards and best practices.
Maintain strong business functional knowledge alongside up-to-date expertise in automated technologies and tools.
Comply with all policies and procedures related to confidential information, including internal and restricted data.
Qualifications:
Required
Minimum 7 years of experience as a Data Engineer on Enterprise Data Warehousing (DWH) and Business Intelligence (BI) projects, both on-premises and cloud (Azure), with at least 3 years of hands-on experience using Microsoft technologies such as SQL Server, Synapse, SSIS, Data Factory, and Databricks.
Proficiency in scripting languages such as Python, C#, or their equivalents.
Advanced experience with MS SQL Server, MySQL, or Oracle databases.
Familiarity with Big Data technologies including NoSQL databases, Hive, HBase, Pig, or Spark.
Practical experience in ETL development using SSIS and Data Factory.
In-depth knowledge of Master Data Management, ETL, data quality, metadata management, data profiling, micro-batching, and streaming data ingestion.
Experience working with one or more scalable (MPP) relational databases such as Synapse or Snowflake for advanced analytics workloads.
Knowledge of application and system availability, scalability, and distributed data platforms.
Strong background in data warehousing technologies and ETL/ELT implementations.
Familiarity with the full Software Development Life Cycle (SDLC).
Experience working within Lean or Agile development methodologies.
Proven ability to provide technical leadership and mentor other engineers on best practices within data engineering.
Desired
Experience in defining new architectural frameworks and leading independent projects from an architectural perspective.
Familiarity with data modeling and ETL tools such as Erwin and Talend.
Ability to support users by troubleshooting and tuning queries, including partitioning and bucketing recommendations.
Experience designing and implementing ETL/ELT frameworks for complex warehouses and marts, with knowledge of large data sets, performance tuning, and troubleshooting.
A hands-on development approach with a willingness to address and resolve complex technical issues.
Exposure to Continuous Integration / Continuous Deployment (CI/CD) processes.
Excellent verbal and written communication skills.
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
Questions about this role
How do I apply to this SSIS and Azure Data Engineer role at Weekday?
Click "Apply with AI Applyd" above. We auto-fill the application from your resume and answer screening questions in seconds. No copy and paste, no juggling tabs.
What's the typical salary for Data Engineer in India?
Compensation for Data Engineer roles in India varies widely by seniority, employer size, and remote vs onsite arrangement. Check the salary range on this listing when published, or browse our Data Engineer hub for India medians across recent openings.
How fast does AI Applyd auto-apply?
Most applications complete in under 90 seconds. You can track the status in your dashboard and watch the screenshot proof land the moment the application submits.
What ATS does Weekday use?
AI Applyd supports Greenhouse, Lever, Ashby, Workday, iCIMS, SmartRecruiters, LinkedIn Easy Apply, and most other ATS platforms. If we can submit through the platform, we do.
Want AI Applyd to auto-apply to roles like this?
We tailor your resume per posting, fill the forms, and track replies for you.