Software Developer II (Informatica Cloud Developer)

S&P Global Corporate

The Role: Software Developer II (Informatica Cloud Developer)

The Team: Each of our employees plays a vital role—uncovering the essential intelligence that our clients rely on day in and day out to make the decisions that matter. We provide intelligence that is essential for companies, governments and individuals to make Decisions with conviction. We pursue excellence in everything we do. We value results, encourage teamwork and embrace change.

The Impact:

Contribute significantly to the growth of the firm by:

• Creating diverse workforce and an inclusive workplace are essential to our success

• Understanding the business needs every day and enhance IT services

• Visit, seek out views, listen and talk with staff

• Drive employee engagement higher to yield greater productivity at work with complete satisfaction

What’s in it for you:

• This position provides a tremendous opportunity to grow personally and professionally in this role.  

• This is the place to learn and enhance your development skills while having the chance to work on enterprise level products and new technologies.

• We invest in the right technology and people, so we can turn raw data into actionable insights. That is why we are critical to governments, companies and individuals the world over.

• Our systems support the operational Excellence in all that we do.

Responsibilities:

• Provide technical knowledge/expertise to support the requirements definition, design, and development of data warehouse components/subsystems, specifically Extract-Transform-Load or Extract-Load-Transform technologies and implementations and/or Change Data Capture technologies and implementations.

• Research, design, develop, and modify the ETL and related database functions, implementing changes/enhancements to the system

• Design ETL processes and develop source to target data mappings, Data Synchronization tasks, and load processes.

• Develop, test, integrate and deploy ETL code using ETL tools and external programming/scripting languages, as necessary.

• Research, design, develop, and modify the Change Data Capture (CDC) and related functions

• Administer and maintain the ETL/CDC environment, including performing configuration management activities related to the ETL/CDC environment

• Resolve requests for assistance in troubleshooting issues assigned to the development team

• Support functional/regression testing activities in support of system functionality releases, patches and upgrades

• Support Production jobs and debug for any issues during Failures, perform the RCA for failure and fix the issue to resume the operations.

• Knowledge in scheduling tools like TWS, Informatica Schedulers.

• Analyze process improvement areas/recommend changes to processes/procedures for efficiencies/cost-savings/etc.

What we’re looking for:

• 5 years of experience in developing, testing, and deploying ETL and/or CDC solutions (utilizing Informatica Intelligent cloud services, Informatica PowerCenter)

• Database programming skills

• Experience with Data warehouse technologies including ETL Data transformations

• Experience in best practices design of ETL implementations in a high volume environment, including ETL software, database and tuning.

• Experience in best practices design of CDC implementations in a high volume environment, including CDC software, database and tuning.

• Basic Knowledge in EBS Technology

• Experience with Developing and maintaining Code using IICS.

• Experience using IICS as middleware for integrations with EBS, Salesforce, Zuora, Servicenow and AzureDevops and AmazonS3.

• Knowledge of salesforce Data objects, and operations like Data Extraction and Load.

• Knowledge of underlying Oracle ERP applications database architecture

• Knowledge on Zuora API’s and Zuora Application.

• Experience with Software Configuration Management tools (e.g. PVCS)

• Experience in Developing Web services, Real time connectors and REST/SOAP API Calls for Real time Integrations.

• Experience in implementing REST V2 Based connections using swagger file for Integrations.

• Understanding of Informatica REST API guidelines to access and pass information to Informatica Cloud organization.

• Experienced in creating and publishing processes in Informatica cloud real time (ICRT) process designer using service connectors like REST, JDBC, File

• Experienced in monitoring and debugging published processes from ICRT process console

• Experience in writing Performance efficient complex SQL queries and tuning existing queries.

• Experience in designing, writing, and maintaining Linux Operating System Shell scripts and utilizing Linux system utilities.

• Basic Knowledge in EBS Technology and good knowledge at  Database sql query writing will be a addon.

• Minimal knowledge on how to verify the details at EBS finance front end application.

Return to Work:

Have you taken time out for caring responsibilities and are now looking to return to work? As part of our Return to Work initiative (link to career site page when available), we are encouraging enthusiastic and talented returners to apply, and will actively support your return to the workplace.

Grade/Level: 9

The Location: Hyderabad, Islamabad

About Company Statement:

S&P Global delivers essential intelligence that powers decision making. We provide the world’s leading organizations with the right data, connected technologies and expertise they need to move ahead. As part of our team, you’ll help solve complex challenges that equip businesses, governments and individuals with the knowledge to adapt to a changing economic landscape.

S&P Global Engineering Solutions solves for tomorrow’s challenges today by transforming workflows and end-user experiences with data, insights and technology.