Senior Software Engineer

ValueMomentum; Hyderabad; On-site; INR 1,500,000 - 2,200,000; Full time

Benefits offered by this job

Health benefits

Life insurance

Career growth & training

Job summary

ValueMomentum seeks a Senior ETL Developer to design, develop and maintain scalable ETL processes using IBM CP4D and DataStage. You will work with business teams, data modelers, and cross-functional stakeholders to deliver robust data integration solutions and ensure data quality across pipelines.

Ideal candidates have hands-on IBM CP4D/DataStage, SQL with DB2, Unix scripting, and a solid understanding of data warehousing concepts, contributing to offshore/onshore projects from Hyderabad.

Qualifications

• 4–6 years of ETL development experience with IBM DataStage/CP4D.
• Strong SQL skills with DB2; exposure to Oracle/SQL Server/Snowflake is a plus.
• Experience designing and tuning ETL workflows and data pipelines.

Responsibilities

• Design and develop CP4D/DataStage jobs to load data into data warehouses.
• Develop scalable ETL workflows for large data volumes.
• Translate business requirements into ETL designs and mappings.
• Work with files, APIs/web services, XML/JSON, and databases.
• Create technical design docs, test cases, and issue documentation.
• Monitor ETL jobs in production and support performance improvements.

Skills

Informatica

ETL

IBM CP4D (Cloud Pak for Data)

IBM DataStage

SQL

DB2

Unix Scripting

Tools

IBM DataStage

IBM CP4D

Unix scripting

Job description

Job Title

Senior Software Engineer

Job ID

POS-20475

Primary Skill

Informatica

Key Skills

ETL, IBM CP4D (Cloud Pak for Data), IBM DataStage, SQL, DB2, Unix Scripting

Mode of Work

Work From Office (5 Days)

Job Location

Hyderabad / Pune / Coimbatore

Experience

4 to 6 Years

About The Job

As a Sr. ETL Developer – IBM CP4D, you will be responsible for designing, developing, and maintaining scalable ETL processes using IBM CP4D and DataStage. You will work closely with business teams, data modelers, and cross-functional stakeholders to understand data requirements and build efficient data integration solutions. The role involves developing ETL workflows, implementing source-to-target mappings and transformation logic, handling large data volumes, and ensuring the performance, reliability, and quality of data pipelines. The ideal candidate should have strong hands‑on experience with IBM CP4D/DataStage, ETL development, SQL, DB2, and Unix scripting, along with a good understanding of data warehousing concepts.

Know Your Team

At ValueMomentum Technology Solution Centers, we are a team of passionate engineers solving complex business challenges across the P&C insurance value chain.

Our expertise spans Cloud Engineering, Application Engineering, Data Engineering, Core Engineering, Quality Engineering, and Domain capabilities. Through our Infinity Program, we invest in continuous learning, role‑based skill development, and opportunities to work on impactful global transformation programs.

Responsibilities

• Design and develop CP4D/DataStage jobs to extract, transform, and load data into data warehouses.
• Develop scalable ETL workflows to process large volumes of structured and semi‑structured data.
• Collaborate with business teams and data modelers to understand ETL requirements and translate them into technical solutions.
• Develop mapping documents and transformation rules based on source‑to‑target requirements.
• Work with DataStage Parallel Jobs, Sequence Jobs, Server Jobs, shared containers, parameters, job controls, and restartability.
• Develop and optimize ETL workflows using transformers, joins, lookups, aggregations, funnels, sorts, partitioning, and surrogate‑key handling.
• Perform unit testing and support performance testing of ETL jobs.
• Troubleshoot job failures, performance bottlenecks, metadata/schema issues, connector failures, and parallel‑engine errors.
• Work with files, APIs/web services, XML/JSON, message queues, and relational databases for data integration.
• Create and maintain ETL technical design documentation, test cases, results, and issue documentation.
• Monitor and support ETL jobs in production environments and ensure reliable data processing.
• Work closely with cross‑functional teams to ensure seamless data integration and delivery.

Requirements

• 4–6 years of experience in ETL development with strong hands‑on experience in IBM DataStage/CP4D.
• Strong experience with IBM DataStage Parallel Jobs, Sequence Jobs, Server Jobs, shared containers, parameters, job control, and restartability.
• Strong SQL skills with hands‑on experience in DB2; exposure to Oracle, SQL Server, Snowflake, or similar databases is an advantage.
• Experience developing and tuning ETL workflows using transformations, joins, lookups, aggregations, funnels, sorts, partitioning, and surrogate‑key handling.
• Experience troubleshooting ETL job failures, performance issues, metadata/schema problems, connector failures, and parallel-processing errors.
• Experience integrating files, APIs/web services, XML/JSON, message queues, and relational databases.
• Good knowledge of Linux/Unix commands and shell scripting.
• Understanding of data warehousing, dimensional modelling, data quality, data lineage, and reconciliation controls.
• Experience with source control, CI/CD, code reviews, release management, and production support.
• Ability to translate business requirements into scalable technical designs and ETL specifications.
• Strong analytical, problem‑solving, troubleshooting, and communication skills.
• Experience working in Agile development environments.

Good To Have

• Experience with IBM Cloud Pak for Data implementations.
• Exposure to modern cloud data platforms such as Snowflake.
• Experience with scheduling and orchestration tools.
• Experience working with large‑scale data integration projects.
• Prior experience in the Property & Casualty (P&C) Insurance domain.

About The Company

Founded in 2000 with the core belief that impactful change comes from deep commitment, ValueMomentum specializes in delivering measurable results across the P&C value stream. For more than 25 years, we have empowered more than 100 carriers to reimagine their businesses with AI and emerging technologies, navigate market shifts, unlock speed to value, and become future‑ready. We help insurers in the US, Canada, and Europe stay ahead with sustained growth and high performance to enhance stakeholder value and foster resilient societies.

Our culture – Our fuel

• People firs - Empower employees to succeed.
• Nurture leaders - Nurture from within.
• Enjoy wins - Recognize and celebrate win.
• Collaboration - Foster a culture of collaboration and people‑centricity.
• Diversity - Committed to diversity, equity, and inclusion.
• Fun - Create a fun and engaging work environment

Company Benefits

• Compensation - Competitive compensation package comparable to the best in the industry.
• Career Growth - Career development, comprehensive training & certification programs, and fast track growth for high potential associates.
• Health Benefits: Comprehensive health benefits and life insurance.