ETL Developer

• Senior developer working on BI project which involves Data warehousing, ETL development(Informatica), Data modelling, Reports/dashboard development and to work in global teams and support global cross-functional environment partnering with internal customers to help, support and enhance business systems

Qualifications & Certifications

• Engineering Graduate or Master of Computer Applications (MCA)
• Certified in one or more of the following is an advantage - Informatica - DI, Sql/PSql,

Experience

• 5 years of experience on Informatica, SQL (minimum 2-year experience on each of the tool mentioned)
• Must have worked on at least 2 complete life cycle implementations of BI projects
• Should have Python knowledge.Required Skills (Must have) along with necessary industry experience

General

• Experience in any service industry where Oracle BI is extensively used for their global customers with strong customer centric focus.
• Total experience of 5-8 years, with excellent communication, coordination, and team leadership skills
• Prior experience in handling E2E Product Operations Lifecycle (Ex: ETL/Report, Incident management/Bug-Fix) and E2E Product Engineering lifecycle (ex: Enhancements and Projects with release life cycle experience)
• Ability to evaluate technology solution options for business requirements
• Should be able to identify opportunities for automation and implement the same to bring in efficiencies
• Ability to manage complex stakeholders in a dynamic, matrix organization
• Self-motivated, positive attitude and ability to inject optimism
• Ability to challenge status quo and lead discussions in the right direction
• Ability to collaborate with various teams locally and globally
• Ability to influence without authority
• Ability to articulate thoughts and ideas clearly
• Excellent interpersonal skills, ability to negotiate the best things for the organization
• Crisis, conflict, issues management skills
• Eye for detail as well as understanding of the big picture
• Ability to work with ambiguous information

Functional

• Preferably HCM domain and process knowledge or prior experience of any data warehouse/ERP implementation.
• Ability to gather requirements and convert business requirements to technical requirements
• Providing effort estimations to complex BI projects
• Engage with cross teams to analyze data sources required to integrate for a new analytical solution
• Maintain and enhance operating rhythm
• Experience in managing challenging stakeholders
• Ability to validate change requests

Informatica -

• Strong experience in design, development, and testing of Informatica based applications (PowerCenter 2)
• Transformations like Lookup, sorter, Expression, router , update strategy , filter.
• 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).
• Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Expert in using mapping Parameters, Mapping Variables, testing and fixing the issues in Mapping.
• Understand complex transformations such as mapplet, worklet, normalizer and custom transformations.
• Experience in Extract/Load/Transform (ETL)workflows (Informatica PowerCenter) Knowledge on Informatica Cloud services is an advantage. Should have Strong knowledge of Oracle database, PL/SQL development, UNIX scripting.
• Strong knowledge on generic database procedures using PL/SQL Libraries to handle data manipulation and computations of business logic
• Scheduling Execution of PL/SQL Procedures in the database & created Materialized views to calculate aggregated data