Senior Software Developer

S&P Global Corporate 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 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. • Equal Opportunity Employer S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, ****** orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. Only electronic job submissions will be considered for employment. If you need an accommodation during the application process due to a disability, please send an email to: and your request will be forwarded to the appropriate person US Candidates Only: The EEO is the Law Poster describes discrimination protections under federal law. 20 • 20 Professional (EEO2 Job Categories-United States of America), IFTECH20 Middle Professional Tier I (EEO Job Group), SWP Priority Ratings (Strategic Workforce Planning) • 20 Professional (EEO2 Job Categories-United States of America), IFTECH20 Middle Professional Tier I (EEO Job Group), SWP Priority Ratings (Strategic Workforce Planning) • 20 Professional (EEO2 Job Categories-United States of America), IFTECH20 Middle Professional Tier I (EEO Job Group), SWP Priority Ratings (Strategic Workforce Planning