Sr. Data Engineer

Systems Plus; Pune District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Systems Plus in Pune is seeking a Sr. Data Engineer to lead ETL development, ensure data integrity and develop API integrations using IICS. You will work with cloud storages and modern data platforms like Snowflake, Data Bricks or Azure Synapse.

The role requires strong data analysis capabilities, SDLC/Agile experience, and the ability to drive architecture and data quality across teams.

Qualifications

• Experience leading ETL development and data integration projects.
• Proven ability to design and optimize data pipelines using IICS.
• Strong SQL/PLSQL skills and data quality focus.
• Hands-on with cloud storages like Azure Data Lake or S3 and data platforms.
• Knowledge of Snowflake, Data Bricks or Azure Synapse architectures.

Responsibilities

• Lead design, development and maintenance of ETL solutions for data warehousing.
• Collaborate with business to translate requirements into technical specs.
• Apply SDLC and agile practices; plan user stories and tasks.
• Performance tune ETL jobs, SQL queries and scripts.
• Configure scheduled ETL jobs and CI/CD for IICS pipelines.
• Develop advanced SQL procedures and data integrations.
• Support data analysis, analytics and predictive modeling.
• Integrate data from internal and external sources; troubleshoot issues.
• Work with cloud platforms like Snowflake, Data Bricks or Synapse.
• Contribute to data architecture, storage and reporting standards.

Skills

ETL Development

IICS

SQL / PL/SQL

Cloud Data Platforms

Data Bricks

Snowflake

Azure Synapse

CI/CD

UNIX / PowerShell

API Integrations

SDLC / Agile

Data Analysis

Tools

Informatica Intelligent Cloud Services (IICS)

Job description

HIRING www.systems-plus.com

Sr. Data Engineer

Location: Pune Employment Type: full-time Designation: Sr. Data Engineer

Job Details

GDC - Senior Data Engineer

Job Description

Supervisor's Title

Manager or Technical Lead

Primary Purpose

The Senior Data Engineer will be responsible for leading and developing ETL solutions, maintaining data integrity, data quality and development of API integrations using services from the IICS platform. This position will also develop and manage integration with cloud storages like Azure Data Lake, AWS S3 and cloud data platforms like Snowflake, Data Bricks or Azure Synapse. The ideal candidate will also have proven experience in data analysis and management, with excellent analytical and problem-solving abilities.

Major Functions/Responsibilities

• Design, develop and implement robust and extensible ETL solutions to support data warehouse integrations and transformations using CDI/CAI services on IICS platform, UNIX/PowerShell.
• Partner with business and subject matter experts to identify, document & design based on the business requirements, functional specs and translate them into appropriate technical solutions
• Understand the Software Development Lifecycle and ability to apply the SDLC to existing and future development initiatives.
• Responsible forestimating, planning and managing the user stories, tasks and reports on Agile Projects.
• Performance tuning and optimizations of ETL Jobs, SQL Queries and Scripts.
• Configure and maintain scheduled ETL jobs
• Manage and Implement CICD for Informatica Intelligent Cloud Services ETL pipelines.
• Develop advanced PLSQL Procedures, Functions and SQL jobs.
• Support exploratory data analysis, statistical analysis and predictive analytics
• Develop data integrations between internal and external/third party sources
• Support production issues and maintain existing data systems by researching and trouble-shooting any issues/problems in a timely manner.
• Develop technical solutions using Data Bricks, Snowflake or Azure Synapse architecture.
• Participate in the development of corporate-wide strategies, processes, and standards for data architecture, storage and reporting.
• Proactive, great attention to detail, results-oriented problem solver.

Decision Making Authority

• This position needs to possess the ability to act quickly with independent thinking and sound judgment.
• Works under the direction of data architect or manager of data analytics.
• Ability to make required and immediate decisions on his/her own and elevate complex issues as needed.