ETL Developer

Pinnacle Group, Inc.; India; Hybrid; INR 800,000 - 1,200,000; Full time

Job summary

A leading workforce solutions provider in India is seeking an experienced ETL Developer for a full-time position in Chennai. The ideal candidate will have over 3 years of experience in ETL development, with a strong focus on SQL and data warehouse design. Responsibilities include developing and optimizing ETL processes using SSIS and Azure Data Factory while collaborating with cross-functional teams. This role offers a hybrid work environment and competitive compensation.

Qualifications

• 3+ years of experience in ETL development.
• Proven experience with SSIS and Azure Data Factory.
• Strong understanding of ETL concepts, tools, and best practices.

Responsibilities

• Design, develop, and maintain ETL processes using SSIS and Azure Data Factory.
• Architect and implement data warehouse solutions.
• Create and maintain data models for analytical needs.

Skills

ETL development

SQL

Data Warehouse design

Data modeling

Data integration

Performance optimization

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server Integration Services (SSIS)

Azure Data Factory

Job description

Shaping the Future of PTR Global | Connecting Talent with Opportunity

About Pinnacle Group:

Pinnacle Group is a leading workforce solutions provider that empowers organizations to achieve their business objectives through innovative workforce strategies. We specialize in optimizing contingent workforce management and delivering tailored solutions that drive operational excellence. With a commitment to diversity and inclusion, Pinnacle Group fosters an environment of collaboration, growth, and success.

Summary:

We are seeking an experienced ETL Developer to join our dynamic team. The ideal candidate will have a strong background in SQL, ETL processes, and Data Warehouse design and modeling. This role will be responsible for developing, maintaining, and optimizing ETL solutions using SSIS and Azure Data Factory to support our data integration and analytics initiatives.

Key Responsibilities

• ETL Development: Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) and Azure Data Factory.
• Data Warehouse Design: Architect and implement data warehouse solutions, ensuring optimal design for data integration, storage, and retrieval.
• Data Modeling: Create and maintain data models, ensuring they meet business requirements and support analytical needs.
• Data Integration: Integrate data from various sources, ensuring data quality and consistency.
• Performance Optimization: Monitor ETL processes and data warehouse performance, implementing optimizations as needed.
• Collaboration: Work closely with business analysts, data scientists, and other stakeholders to understand data requirements and deliver effective solutions.
• Documentation: Maintain comprehensive documentation of ETL processes, data models, and data flows.
• Support: Provide support for data-related issues, troubleshooting and resolving problems as they arise.

Required Skills and Qualifications

Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.

• 3+ years of experience in ETL development.
• Proven experience with SQL Server Integration Services (SSIS) and Azure Data Factory.
• Experience in data warehouse design and modeling.
• Proficient in SQL, including complex queries, stored procedures, and performance tuning.
• Strong understanding of ETL concepts, tools, and best practices.
• Experience with data modeling tools and methodologies.
• Familiarity with data integration from various sources (e.g., APIs, flat files, databases).
• Knowledge of cloud data warehousing solutions (e.g., Azure Synapse Analytics, Snowflake) is a plus.
• Excellent problem-solving and analytical skills, with a keen attention to detail.
• Strong verbal and written communication skills, with the ability to convey complex technical concepts to non-technical stakeholders.
• Ability to work effectively both independently and as part of a team.

Preferred Skills

• Experience with other ETL tools and platforms.
• Knowledge of data governance and data quality principles.
• Understanding of big data technologies (e.g., Hadoop, Spark) is a plus.
• Experience with BI tools (e.g., Power BI, Tableau) for data visualization and reporting.

Working Conditions

This is an onsite position in Chennai with shift time 6:30 PM - 3:30 AM. The position is full-time and a hybrid work environment is available.

• Full-time position.
• Hybrid work environment.

Seniority level

Associate

Employment type

Full-time

Job function

Information Technology

Industries

IT Services and IT Consulting