This website uses cookies to ensure you get the best experience. Learn more
IHS Markit

ETL Developer/Software Engineer - CARFAX-1


ETL Developer / Software Engineer

Years of Experience - 4-6 years

Location - Gurgaon

Department - Business Intelligence

Reporting to Yogesh Manglani

Shift Timings - 2:00PM to 11:00PM IST

Department overview

Join our Winning Team as a Data Integration Specialist

When was the last time you bragged about where you work? At CARFAX, we do it every day. Why? Because we're proud to work for a company with a strong mission and trusted brand. We're proud to work with people who care about what they do and work hard every day to deliver their best. We've created the type of company culture where the term, "work- hard play- hard" is taken to new heights. Even today, while working remotely, our culture is strong and our team is connected!

Position summary

As a Data Integration Specialist on the Business Intelligence (BI) team you will help provide trusted reporting, data, and analytics for CARFAX to demonstrate value across business channels, assess product performance to influence direction, support internal business operations, and external customer facing products. You'll play a key role in BI DevSecOps team to ensure data processes meet expected quality standards and SLAs.

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: 4 to 6 years
  • Specific skills:
  • Strong SQL and PL/SQL skills
  • Experience in developing complex ETL mappings, workflows, mapplets in Informatica
  • 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 and onsite-offshore project model
  • Experience with Informatica Cloud based implementations
  • Experience with Snaplogic and Data Lake highly preferred.
  • Experience scheduling jobs using Control-M a plus

  • Personal characteristics
    • Carfax prefers collaboration over video conference. Candidate should be comfortable with the same.
  • Certifications etc
    • Informatica or other ETL tools
    • SQL certifications
What You'll Love About Us - Do ask us about these!
  • Total Rewards. Monetary, beneficial and developmental rewards!
  • Work Life Balance. You can't do a good job if your job is all you do!
  • Prepare for the Future.  Academy - we are all learners; we are all teachers!
  • Employee Assistance Program. Confidential and Professional Counselling and Consulting.
  • Diversity & Inclusion. HeForShe!
  • Internal Mobility. Grow with us!

Company overview

IHS Markit harnesses deep sources of information, analytics and expertise to forge solutions for the industries and markets that drive global economies. Our company partners with clients in business, finance and government to provide the unrivalled insights and perspectives that lead to well-informed, confident decisions. We call this The New Intelligence.

IHS Markit serves more than 50,000 key customers in more than 140 countries, including 80 percent of the Fortune Global 500.  We help decision makers apply higher-level thinking to daily tasks and strategic issues across a host of industries and disciplines including energy, finance, automotive, engineering, technology, maritime and trade, chemical, and economics and country risk. 

Headquartered in London, IHS Markit (Nasdaq: INFO) is committed to sustainable, profitable growth. 

                             

-----------------------------------------------

Inclusion and diversity are critical to the success of IHS Markit, and we actively encourage applications from people of all backgrounds. We are committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, status as a protected veteran, or any other protected category. For more information on the many ways in which we enthusiastically support inclusion and diversity efforts for both candidates and employees, please access our Inclusion & Diversity Statement here.

We are proud to provide reasonable accommodations to applicants with disabilities. If you are interested in applying for employment with IHS Markit and need special assistance or an accommodation to use our website or to apply for a position, please  contact  or call +1 212 849 0399. Determination on requests for reasonable accommodation are considered on a case-by-case basis. This contact information (email and phone) is intended for application assistance and accommodation requests only. We are unable to accept resumes or provide information about application status through the phone number or email address above. Resumes are only accepted through the online application process, and only qualified candidates will receive consideration and follow-up.

IHS Markit maintains a substance-free workplace; employees may be asked to submit to a drug test (where permitted by law).  In addition, as a federal contractor in the United States, the company participates in the E-Verify Program to confirm eligibility to work.

For information please click on the following links:

IHS Markit Business Code of Conduct
Right to Work
EEO is the Law
EEO is the Law Supplement
Pay Transparency

-----------------------------------------------

Current Colleagues

If you are currently employed by IHS Markit, please apply internally via the Workday internal careers site.

Apply Now

Share this