Snaplogic Developer

Teksystems; Hyderabad, Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Teksystems in Hyderabad is seeking an experienced ETL Developer to migrate legacy data workflows to SnapLogic, build scalable pipelines, and drive cloud-based data integration.

You will leverage Informatica/SSIS migration, AWS services, and IaC with CloudFormation, while strengthening data quality, performance, and automation through shell scripting and SQL.

Join a team that values reliable data operations and knowledge-sharing across data architects and business analysts.

Qualifications

• Migrate ETL workflows from Informatica/SSIS to SnapLogic.
• Design and develop SnapLogic pipelines for data ingestion, transformation and loading.
• Implement cloud-based ETL using AWS services (S3, Lambda, Glue, CloudWatch).
• Use CloudFormation for provisioning ETL environments.
• Write and maintain shell scripts for automation.
• Develop and optimize SQL queries and stored procedures for data processing.
• Collaborate with data architects and analysts to ensure data quality and performance.

Responsibilities

• Migrate existing ETL workflows from Informatica and SSIS to SnapLogic.
• Design and develop new ETL pipelines using SnapLogic for data ingestion, transformation, and loading.
• Monitor and troubleshoot ETL jobs to ensure reliability and scalability.
• Document processes and provide knowledge transfer to team members.

Skills

SQL queries

Shell scripting

Data integration

Tools

SnapLogic

Informatica

SSIS

AWS S3

AWS Lambda

AWS Glue

CloudWatch

CloudFormation

Job description

Role & responsibilities:

• Migrate existing ETL workflows from Informatica and SSIS to SnapLogic.
• Design and develop new ETL pipelines using SnapLogic for data ingestion, transformation, and loading.
• Implement cloud-based ETL solutions leveraging:
• AWS Services: S3 for storage, Lambda for serverless processing, Glue for ETL orchestration, and CloudWatch for monitoring.
• Infrastructure as Code: CloudFormation for provisioning ETL environments.
• Write and maintain shell scripts for automation and job orchestration.
• Develop and optimize SQL queries, stored procedures, and scripts for data processing.
• Collaborate with data architects and business analysts to understand data requirements and ensure accurate data flow.
• Implement best practices for data quality, error handling, and performance tuning.
• Monitor and troubleshoot ETL jobs to ensure reliability and scalability.
• Document processes and provide knowledge transfer to team members.

Preferred candidate profile:

We are looking for an experienced ETL Developer to design, develop, and migrate data integration workflows from legacy platforms to modern solutions. The role involves transitioning ETL processes from Informatica and SSIS to SnapLogic, implementing automation using shell scripting, and ensuring robust data operations through SQL expertise. The candidate will also work on cloud-based ETL orchestration and data pipelines