ETL Developer

You must Sign In before continuing to the company website to apply.

Smart SummaryPowered by Roshi

Collaborate with product managers, BI Reporting Specialists, and other project stakeholders to understand data/reporting requirements and goals. Perform data analysis to check requirements feasibility. Share data findings with project stakeholders to make appropriate project decisions. Collaborate with Architect and other BI team members to design optimal data pipelines. Translate business requirements into technical specifications, including source to target mappings (STTM). Develop and test efficient ETL solutions using Informatica or external programming/scripting languages. Monitor and support daily data load jobs to ensure timely completion.

What You'll Do

Collaborate with product managers, BI Reporting Specialists, and other project stakeholders to understand data/ reporting requirements and goals.
Perform data analysis to check requirements feasibility. Share data findings with project stakeholders to make appropriate project decisions.
Collaborate with Architect and other BI team members to design optimal data pipelines. Translate business requirements into technical specification, including source to target mappings (STTM).
Follow STTMs and design guidelines to develop and test efficient ETL solutions using Informatica or external programming/ scripting languages, if necessary.
Identify and reuse ETL components and services to avoid duplicative implementations
Integrate ETL routines into production job streams
Monitor and support daily data load jobs to ensure timely completion.
Address all data load warnings or errors. Take appropriate actions to independently resolve data load issues. Proactively communicate external team dependencies to US based BI team and source data owners.

What You Need to Get the Job Done

Education level: Bachelors in Information technology, Computer Science or equivalent experience.
Year of Experience: 5 to 8years
Specific skills:
Strong SQL and PL/SQL skills
Experience in developing complex ETL mappings, workflows, mapplets in Informatica Cloud (IICS/IDMC)
Experience using Informatica Power Centre Designer, Workflow Manager, Workflow Monitor, and Repository
Experience in unit testing and troubleshooting of ETL jobs
Significant experience optimizing ETL routines and environments
Experience working on Redshift and other AWS tools/ tech.
Ability to work effectively in a rapidly changing, team-based environment
Excellent Communication and collaboration skills with business and technical teams

Preferred skills:
Experience in Agile methodology
Experience with Data Lake highly preferred.
Experience scheduling jobs using Control-M

Personal characteristics
- Carfax prefers collaboration over video conference. Candidate should be comfortable with the same.
Certifications etc
- Informatica or other ETL tools
- SQL certifications

Set alert for similar jobsETL Developer role in Gurgaon, India

Company

S&P Global

Job Posted

a year ago

Job Type

Full-time

WorkMode

On-site

Experience Level

3-7 years

Related Jobs

Software Developer

S&P Global

Gurgaon, Haryana, India

Posted: a year ago

We are hiring for the position of Software Developer at S&P Global in Gurgaon, Haryana, India. As a software developer, you will be responsible for developing high-quality database solutions and implementing stored procedures using T-SQL. You will also be involved in analyzing and improving SQL queries for performance. This is a full-time on-site opportunity, and we are looking for a team player with excellent technical knowledge and analytical skills.

Salesforce Developer

S&P Global

Gurgaon, Haryana, India

Posted: a year ago

We are looking for highly motivated technology professionals who will strengthen our specialisms and create a collaborative, respectful, and inclusive company. Join our team based out of Gurgaon and work with colleagues globally. Must have 7-10 years' experience in Salesforce development.

Sr. Software Developer

S&P Global

Gurgaon, Haryana, India

Posted: a year ago

We are seeking highly motivated technology professionals with 7-10 years of Java development experience to join our expanding portfolio of Financial Services clients in Gurgaon. The candidate will be responsible for high-quality software development, collaborating with Business Analysts and Quality Assurance to meet project requirements and resolve bugs efficiently. Join our team and be a part of a collaborative, respectful, and inclusive company.

Software Developer - Java

S&P Global

Gurgaon, Haryana, India

+2 more

Posted: a year ago

We're hiring a Software Developer - Java for Sustainable1. Join our team to accelerate our automation efforts. You'll work on improving the architecture, design, scalability, and performance of our automation platform. It's a fast-paced agile environment dealing with huge volumes of data. You'll have the opportunity to sharpen your data skills and work on an emerging technology stack.

Lead Software Developer(Java)

S&P Global

Hyderabad, Telangana, India

+2 more

Posted: a year ago

We are seeking a Lead Software Developer with strong experience in Java to join our global technology team. Your responsibilities will include designing and developing Java applications for S&P Multi Asset indices, participating in software development processes, and integrating applications with various vendor software platforms. You should have a Bachelor's degree in Computer Science or a related field, at least 5 years of IT experience, and proficiency in Java, J2EE, and Spring framework. Additionally, experience with Rest Services, API gateway, Oracle Database, and cloud providers like AWS is required. Strong communication and interpersonal skills are a must.

Quality Engineer II

S&P Global

Gurgaon, Haryana, India

Posted: a year ago

Join S&P Global, an equal opportunity employer. We value diversity and provide a fair and inclusive workplace for all qualified candidates. Submit your job application electronically.