Informatica Developer

Company: iSpace, Inc
Location: Burbank
Posted on: January 14, 2020

Job Description:

Applications Developer ETL/DWLocation: Burbank, CADuration: fulltime Position Summary The Applications Developer ETL/DW-- 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 ResponsibilitiesInteracting 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 PackagesLeverage 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.RequirementsBA/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 practicesA self-starting team player with willingness to learn new tools and framework. - provided by Dice

Keywords: iSpace, Inc, Burbank , Informatica Developer, IT / Software / Systems , Burbank, California