Informatica Developer

informatica, ETL, DW, Datawarehouse, PL/SQL, Oracle, "stored procedures", ODI
Contract W2, 6 Months
Depends on Experience
Work from home not available Travel not required

Job Description





Applications Developer ETL/DW
Location: Burbank, CA
Duration: 6 Months Contract


Position Summary
The Applications Developer ETL/DW will work within Aramark Uniform Services IT department and is responsible for supporting the data integration needs of Enterprise Data Warehouse and other integration solutions.
Applications Developer ETL/DW will design robust and scalable data integration solutions based on industry best practices. The candidate must have a strong hands-on experience working in Data Warehousing, Modeling, Integration environment.

Essential Duties and Responsibilities



  • Interacting with Users and SMEs to understand reporting requirements and identify the data sources to fulfill reporting requirements.

  • Develop source to target data mappings as part of ETL / ELT process.

  • Building a reconciliation and exception processes to keep the data accurate for reporting and to keep checks and balances with source data.

  • Ensure to deliver optimized ETL design to achieve acceptable performance and utilize the database and ETL resources effectively.

  • Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners.

  • Working with Reporting teams to facilitate delivering the reporting solutions.

  • Must be able to estimate the work and provide delivery timelines.

  • Design and Build ETL / ELT solutions utilizing Data Analysis, Dimensional Modeling and ETL Design.

  • ETL/ELT performance tuning and optimization in Oracle database environment.

  • Maintenance and support nightly batch schedule.

  • Support Oracle 11.x and 12.x using PL/SQL, Stored Procedures, Functions and Packages

  • Leverage best practices, disciplined approaches, and standards to solving technical problems.

  • Perform ongoing monitoring, optimization, and refinement of reports and BI solutions.

  • Collaborate and work with cross functional IT teams.



Requirements



  • BA/BS degree in Computer Science or related field.

  • 5 years working in IT with experience in Financials, Sales and Marketing Data Warehouse projects.

  • Strong experience working with the ETL tools (design and development).

  • Must have hands-on expertise in PL/SQL, Stored Procedures, Functions and Packages.

  • Solid understanding of requirements for Data Quality, Metadata, Data Lineage, Operational Data Management and Operational Data Stores.

  • Strong Experience in Financial, Sales and Marketing Data Warehouse environment is highly desirable.

  • Knowledge of Informatica, Oracle Data Integrator will be big plus.

  • Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy and plan, Data archiving, Data reconciliation, ETL Error Handling, Error logging mechanisms and proactive monitoring, standards and best practices

  • A self-starting team player with willingness to learn new tools and framework.



Posted By

Naveen Chilagani

Contact
Dice Id : 10106153
Position Id : 19-00266
Have a Job? Post it

Similar Positions

Informatica Developer
  • Sharp Decisions
  • Torrance, CA
Sr. Informatica Developer
  • Tentek, Inc.
  • Torrance, CA
Informatica Cloud Developer
  • Farmers Insurance
  • Woodland Hills, CA
Informatica/ETL Developer
  • Calance
  • Torrance, CA
Sr ETL/Informatica Developer
  • Loganbritton
  • Los Angeles, CA
ETL Developer
  • Rudra Technologies
  • Torrance, CA
Informatica MDM Consultant
  • West Coast Consulting LLC
  • Los Angeles, CA
Informatica Teradata Consultant
  • Cystems Logic
  • Universal City, California
Informatica Admin
  • Net2Source Inc.
  • Los Angeles, CA
ETL Developer
  • Palnar
  • Los Angeles, CA
Informatica MDM Developer
  • DEEGIT, INC.
  • Walnut Park, California
ETL/Informatica Analyst/Developer
  • Delta Computer Consulting Inc
  • Torrance, CA
ETL/Informatica Analyst/Developer 25540
  • UNICON International, Inc.
  • Torrance, CA
Informatica Developer/Tech Lead
  • Sysmind, LLC
  • Woodland Hills, CA
ETL Developer/Analyst
  • Atrilogy Solutions Group, Inc.
  • Los Angeles, CA