Senior Software Engineer

ValueMomentum, Inc.; Hyderabad; On-site; INR 1,500,000 - 2,100,000; Full time

Benefits offered by this job

Competitive compensation package

Career development & certification

Health benefits

Job summary

ValueMomentum is seeking a Senior Software Engineer to design, develop, and maintain scalable ETL processes using IBM CP4D and DataStage. You will collaborate with cross-functional teams to translate requirements into robust data integration solutions.

The role focuses on building and optimizing CP4D/DataStage workflows, handling large data volumes, and ensuring performance and quality of data pipelines, with strong SQL/DB2 and Unix scripting skills.

Qualifications

• 4–6 years of ETL development experience with hands-on experience in IBM DataStage/CP4D.
• Strong knowledge of DataStage Parallel/Sequence/Server Jobs and restartability.
• Proficiency in SQL with DB2; exposure to Oracle/SQL Server/Snowflake is a plus.

Responsibilities

• Design and develop CP4D/DataStage jobs to load data into data warehouses.
• Develop scalable ETL workflows for large volumes of structured and semi-structured data.
• Translate business requirements into technical ETL solutions and maintain documentation.

Skills

ETL

IBM CP4D

IBM DataStage

SQL

DB2

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

At ValueMomentum, we believe in making employees win by nurturing them from within, collaborating and looking out for each other.

• 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.