Remote-Junior ETL Support Developer (2-3 years profile) for C2H (Citizen and GC)

Junior ETL support developer for CTH position. • Compensation would be around 65K per annum with Benefits • Experience 2-3 years • CTH Yes, 6-month CTH.

Total position 2 Application Support Engineer - ETL & Informatica ETL/Informatica Application Support Engineer with strong analytical skills, excellent troubleshooting abilities, and a proactive approach.

The ideal candidate will drive stability and continuous improvement in production environments, working independently in a fast-paced setting while delivering high-quality support within the Applications Support team.

Key Responsibilities The individual will be involved in the following critical support and operational activities: • Monitor, support, and troubleshoot ETL and data integration workflows across production, QA, and development environments to ensure smooth daily operations. • Analyse and resolve incidents, job failures, and performance issues related to Informatica workflows, mappings, and SQL jobs. • Own and maintain ETL components including Informatica mappings, metadata, scripts, schedules, and operational procedures.

Identify opportunities to optimize performance, scalability, and reliability of existing jobs/processes. • Ensure stability of data ingestion pipelines spanning batch, nearrealtime, and realtime patterns.

Finetune ETL solutions by developing a deep technical understanding of data flows and upstream/downstream dependencies. • Collaborate with DBAs and Data Architects to implement appropriate data partitioning, indexing, and optimization strategies to enhance job performance. • Develop or modify SQL scripts, stored procedures, database triggers, and queries as part of incident resolution, change requests, or performance tuning. • Work closely with crossfunctional and offshore teams, ensuring timely resolution of issues, clear communication, and adherence to support SLAs and operational guidelines. • Manage multiple concurrent support tickets, change requests, and enhancement tasks, balancing priorities based on business impact and urgency. • Ensure compliance with published support, development, coding, and testing standards, as well as change management practices.

Ideal Experience & Critical Competencies • Strong analytical thinker with the ability to troubleshoot complex data and integration issues effectively. • Flexible, adaptable, and pragmatic, with the ability to remain focused on objectives while handling shifting priorities. • 3-5 years of experience in ETL application support, Informatica PowerCenter/Cloud, and SQL Server in production environments. • Practical experience with SQL Server, including schema understanding, stored procedure development, query tuning, and optimization. • Handson experience with job scheduling tools such as ControlM or AutoSys for monitoring and support automation. • Excellent communication skills and ability to work both independently and as part of a distributed global team. • Bachelor s degree in a technology or engineering field.