Logo
Target Labs, Inc

ETL/BI ANALYST & TECHNICAL LEAD

Target Labs, Inc, Columbus, Indiana, United States, 47201


```htmlJob DescriptionExperience:

6+ Years in ETL design, OBIEE/Essbase, strong in Oracle SQL, PL/SQL data analysis.

Key Responsibilities:

Strong exposure to Data, ETL Informatica systems analysis.

Experience in Requirements gathering & Analysis.

Strong Oracle SQL, PL/SQL query-based data analysis ability.

Experience/Exposure to Essbase is an added advantage.

Experience in Sales & Marketing and Manufacturing Data Warehouse will be advantageous.

Expertise in performance engineering in ETL applications.

User interface experience with good verbal and written communication skills.

Responsible for translating business needs into technical solutions and specifications, and designing relational and dimensional models to meet project requirements.

Develop, manage, and update conceptual, logical, and physical data models in a multi-tiered Data Warehouse environment.

Possess proven skills in both dimensional and relational data modeling.

Clear understanding of how ETL (Extraction, Transformation and Loading) and BI (Business Intelligence) tools influence the final database design.

Understand source system database structures and underlying data.

Perform data profiling, analysis, and knowledge transfer expertise to project team members.

Design, develop, maintain, test, reverse engineer, and modify ETL processes within the context of Business Intelligence and Data Warehousing solutions.

Possess proven skills and sound knowledge of ETL/BI processes and best practices, experienced in development activities.

Collaborate with team members throughout the SDLC to perform model reviews, data reviews, issue resolution, and ensure successful delivery of the Panel Reprogramming solution.

Qualifications:

Candidates should have no less than 5 years of experience with Data Analysis, Database Design (ERWin or Embarcadero on Oracle platform), and ETL Development using Informatica Power Center.

Skills:

Strong ETL, Oracle, Essbase system data analysis and DW user requirement gathering & analysis. Good team member, willing to share workload as needed.

Education:

Bachelor of Engineering/Computer Applications, IT & Science in a Master's degree preferred.

Location: Columbus, Indiana.

```#J-18808-Ljbffr