ETL Developer With Informatica + Oracle + UNIX + Control M

Job Summary

Cognizant Technology Solutions Asia Pacific Pte. Ltd
IT/Computers - Software
Kuala Lumpur
Years of Experience
6 - 16 years
Posted On
12th Feb 2021
ETL Developer,Informatica

Job Description:

6+ years of experience required in related field (i.e. ETL Informatica PC, Data Warehousing and SDLC)

• Strong experience in Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger). Experience in Oracle and UNIX shell scripting.

• Assists with tuning of ETL processes and database performance

• Design and develop any/all necessary ETL processes

• Responsible for loading and validating data into the data warehouse

• Knowledge in Dimensions and Facts tables.

• Translated the business processes into Informatica mappings for building the Dimension tables.

• Worked on different tasks such as Event wait, Event Raise and Command.

• Created mappings to build business rules to load data.

• Implemented slowly changing strategy to manage the data in the dimension tables.

• Involved in Code review and manual testing such as Unit testing

• Involved in creating mapping variable, mapping parameter to make the mapping more flexible

• Knowledge in performance tuning to optimize session performance by eliminating performance bottlenecks.

• Prepared Functional spec, Migration document, Unit test case document and support manual.

• Monitoring and tracking the applications as per the schedule run.

• Hands on experience in writing UNIX commands and writing, editing Shell Scripts.

• Hands on experience in creating procedures and functions.

• Hands on working experience in SQL Server and Vertica Databases.

• Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.

• Experience in Extraction, Transformation and Loading of data from homogeneous and heterogeneous source systems like Flat files, SAP R3, Oracle, and SQL Server.

• Outstanding analytical skills, and excellent troubleshooting skills.


About Us:

Cognizant is a global leader in business and technology services that helps Clients bring the future of work to life – today – in a business environment that is being transformed by accelerating globalization, virtualization, and the shift toward cloud technologies.

We continuously seek the “best and the brightest” when we recruit new employees, and we’re consistently an “employer of choice” at leading engineering and business schools around the world. Our domain industry specialists have well-established backgrounds working with companies in the industries we serve.

Our teams and their talent are a principle reason that we consistently outperform the competition.