Analytics Developer

JPS Tech Solutions; Kentucky; Presencial; USD 110.000 - 160.000; Jornada completa

Descripción de la vacante

JPS Tech Solutions Pvt Ltd is seeking an experienced Analytics Developer to design, develop, test, maintain, and support complex ETL processes for an Enterprise Data Warehouse. The role requires hands-on experience with Informatica, Power BI, OBIEE, Oracle Data Visualization, Snowflake, and BigQuery.

You will build BI reporting solutions, optimize SQL/PLSQL, and transform data from multiple sources into reliable enterprise data warehouse solutions.

Formación

• Bachelor’s degree in Computer Science or a related field.
• Minimum 10 years of experience with Power BI, OBIEE, Oracle Data Visualization, Informatica, and/or Snowflake technologies.
• Hands-on experience designing, developing, and optimizing complex Informatica mappings, sessions, and workflows.
• Extensive experience with Informatica Designer components and workflow management tools.
• Strong SQL/PLSQL programming.
• Experience with Oracle RDBMS 12g.
• Knowledge of BI, enterprise data warehousing, and ETL concepts.
• Experience with OBIEE RPD development and BI Publisher data models.
• Ability to analyze data, diagnose issues, and optimize performance.

Responsabilidades

• Design, develop, test, maintain, and support ETL programs for enterprise data warehouse environments.
• Analyze source data and develop transformation logic for accurate data extraction, processing, and loading.
• Develop and maintain BI reporting solutions using Power BI, OBIEE, Oracle Data Visualization, Snowflake, and BigQuery.
• Design and maintain OBIEE Repository (RPD) components and BI Publisher data models.
• Develop cross-functional reporting solutions to support BI requirements.
• Mentor team members and provide technical guidance.

Conocimientos

Advanced SQL/PLSQL

Data warehousing

ETL development

Analytical thinking

Problem solving

Educación

Bachelor’s degree in Computer Science or related field

Herramientas

Power BI

OBIEE

Oracle Data Visualization

Informatica PowerCenter

Informatica Designer

Informatica PowerExchange

OBIEE RPD

BI Publisher

Snowflake

BigQuery

Descripción del empleo

Job Summary

We are seeking an experienced Analytics Developer to design, develop, test, maintain, and support complex ETL processes for an Enterprise Data Warehouse. The ideal candidate will have strong expertise in Business Intelligence, data warehousing, Informatica, Power BI, OBIEE, Oracle Data Visualization, Snowflake, and BigQuery. The role requires hands‑on experience in developing complex Informatica mappings and workflows, building BI reporting solutions, performing advanced SQL and PL/SQL development, and transforming data from multiple source systems into reliable enterprise data warehouse solutions.

Key Responsibilities

• Design, develop, test, maintain, and support complex ETL programs for enterprise data warehouse environments.
• Analyze source data and develop transformation logic to ensure accurate data extraction, processing, and loading into data warehouses.
• Develop and maintain BI reporting solutions using Power BI, OBIEE, Oracle Data Visualization, Snowflake, and BigQuery.
• Design, develop, and maintain OBIEE Repository (RPD) components and BI Publisher (BIP) reporting data models.
• Develop cross‑functional and cross‑system reporting solutions to support business intelligence requirements.
• Design, develop, and manage complex Informatica mappings, sessions, workflows, and mapplets.
• Work with Informatica Designer components, including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, and Workflow Monitor.
• Develop and optimize advanced SQL and PL/SQL queries, database objects, indexing strategies, and query performance.
• Contribute to the design and implementation of metadata, ETL, and reporting components.
• Perform data analysis, root cause analysis, and troubleshooting to identify and resolve data quality and processing issues.
• Analyze complex datasets and develop meaningful reports and visualizations to improve the user experience.
• Translate business processes and requirements into effective BI reporting and analytics solutions.
• Identify BI application performance bottlenecks and implement optimization techniques.
• Participate in solution testing, deployment, and validation activities.
• Follow established SDLC processes, development standards, and project management methodologies.
• Prepare technical deliverables, including detailed design documents, configuration documentation, unit test plans, and training materials.
• Prioritize workloads, manage project deadlines, and work independently with minimal supervision.
• Provide technical guidance, mentoring, and knowledge sharing to team members.

Required Qualifications

• Bachelor’s degree in Computer Science or a related field.
• Minimum 10 years of experience working with Power BI, OBIEE, Oracle Data Visualization, Informatica, and/or Snowflake technologies.
• Strong hands‑on experience designing, developing, and optimizing complex Informatica mappings, sessions, and workflows.
• Extensive experience with Informatica Designer components and workflow management tools.
• Strong programming skills with advanced SQL and PL/SQL.
• Experience with Oracle RDBMS 12g.
• Strong understanding of Business Intelligence, Enterprise Data Warehousing, and ETL concepts and methodologies.
• Experience with OBIEE RPD development and BI Publisher reporting data models.
• Experience with data analysis, data transformation, and root cause analysis.
• Ability to identify and resolve ETL, database, reporting, and application performance issues.
• Understanding of relational databases, indexing, query optimization, and database performance tuning.
• Knowledge of data modeling concepts, including Star Schema, Snowflake Schema, Data Marts, Fact Tables, Dimension Tables, and Slowly Changing Dimensions.
• Understanding of relational and dimensional data modeling, including logical and physical data models.
• Experience working with Unix, Linux, or Windows operating systems.
• Knowledge of version control systems, software engineering principles, and SDLC practices.
• Excellent written and verbal communication, analytical, problem‑solving, and presentation skills.
• Ability to work effectively with business stakeholders and technical teams and translate business problems into technical solutions.
• Ability to mentor and coach team members in a collaborative environment.

Preferred Qualifications

• Minimum 7 years of experience with OBIEE 12.x.
• Minimum 7 years of experience or strong knowledge of Informatica PowerExchange.
• Minimum 7 years of experience with relational, multidimensional, and OLAP technologies and methodologies.
• Experience with Microsoft Power BI and Tableau visualization tools.
• Experience with Snowflake and Google BigQuery.
• Experience with Informatica PowerExchange.
• Experience with Big Data Lake and Hadoop implementations.
• Experience with big data technologies and enterprise data warehouse modernization.

Core Technical Skills

• Power BI and Tableau
• Oracle Business Intelligence Enterprise Edition (OBIEE)
• Oracle Data Visualization
• OBIEE RPD Development
• BI Publisher (BIP) Reporting Data Models
• Informatica PowerCenter and Informatica Designer
• Informatica Mappings, Sessions, Workflows, and Mapplets
• Informatica PowerExchange
• Advanced SQL and PL/SQL
• Oracle RDBMS 12g
• Snowflake and Google BigQuery
• ETL Development and Data Integration
• Enterprise Data Warehousing
• Star Schema and Snowflake Schema Design
• Relational and Dimensional Data Modeling
• Data Marts, Fact Tables, and Dimension Tables
• Slowly Changing Dimensions (SCD)
• OLAP and Multidimensional Data Analysis
• Big Data Lake and Hadoop
• Unix, Linux, and Windows
• Version Control and SDLC
• Performance Tuning and Root Cause Analysis

Professional Skills

• Strong written and verbal communication skills in English.
• Ability to communicate technical solutions effectively to business stakeholders.
• Strong analytical thinking, problem‑solving, and presentation skills.
• Ability to manage multiple priorities and deliver accurate results under project deadlines.
• Ability to work independently and collaboratively within cross‑functional teams.
• Experience mentoring and supporting other technical team members.

[contact-form-7 id="ac31dcc" title="Job Apply Form"]