Senior Analytics Engineer: ETL, BI & Data Warehouse

JPS Tech Solutions; Kentucky; In loco; USD 110.000 - 160.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

Advanced SQL/PLSQL

Data warehousing

ETL development

Analytical thinking

Problem solving

Formazione

Bachelor’s degree in Computer Science or related field

Strumenti

Power BI

OBIEE

Oracle Data Visualization

Informatica PowerCenter

Informatica Designer

Informatica PowerExchange

OBIEE RPD

BI Publisher

Snowflake

BigQuery

Descrizione del lavoro

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.