Description

You will design, develop, and implement data warehousing and business intelligence solutions to meet business requirements.

This role is on-site.

Responsibilities

• Design and write technical specifications for ETL processes, including data mapping and metadata repository definition.
• Implement Informatica mappings, Mapplets, and reusable transformations to migrate and cleanse data from heterogeneous sources.
• Develop Unix shell scripts to automate end-to-end bulk data processing and minimize manual intervention.
• Perform project analysis, architecture design, and implementation of data warehousing initiatives from inception to delivery.
• Fine-tune existing jobs and automate ETL processes through scheduling and exception-handling routines.

Required Skills

• 3+ years of experience as a Database Administrator, Data Analyst, Software Engineer, or Application Development Team Lead.
• Proficiency with Informatica PowerCenter, including Mapplets, Mappings, and sessions.
• Hands-on experience with DB2, Siebel, and Flat Files.
• Strong knowledge of ETL processes and Unix Shell Scripts.
• Technical expertise in Oracle RDBMS and PL/SQL.
• Experience using JIRA for issue tracking and root cause analysis.
• Experience with OLAP and multi-dimensional data modeling.
• Bachelor's degree in Computer Science, Computer Engineering, Computer Applications, Software Development, or Data Science.

Preferred Skills

• Experience with Tableau and DataStage.

Key Skills

Education

Bachelor's degree in Computer Science