- 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 energetic, 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.

- Solid 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

📌 ETL Developer (Bengaluru)
🏢 GForce Consulting Solutions
📍 Bengaluru