Senior Analytics Developer: ETL & BI Expert

JPS Tech Solutions Pvt Ltd; Louisville (KY); On-site; USD 120,000 - 160,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd seeks an experienced Analytics Developer to design, develop, test, and maintain complex ETL processes for an Enterprise Data Warehouse. The role requires hands-on experience with Informatica mappings, BI reporting, and advanced SQL/PL/SQL across Snowflake and BigQuery.

The ideal candidate will own end-to-end data integration, reporting, and performance tuning, collaborating with cross-functional teams to deliver reliable enterprise data solutions.

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.

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.

Skills

Power BI

OBIEE

Informatica

SQL/PLSQL

Snowflake

BigQuery

Oracle Data Visualization

Education

Bachelor's degree in Computer Science

Tools

Informatica PowerCenter

Oracle RDBMS 12g

BI Publisher

Job description

JPS Tech Solutions Pvt Ltd seeks an experienced Analytics Developer to design, develop, test, and maintain complex ETL processes for an Enterprise Data Warehouse. The role requires hands-on experience with Informatica mappings, BI reporting, and advanced SQL/PL/SQL across Snowflake and BigQuery.

The ideal candidate will own end-to-end data integration, reporting, and performance tuning, collaborating with cross-functional teams to deliver reliable enterprise data solutions.