Data Warehouse Developer

 

  • Reviewing requirements with the Business Analysts and Product Management team for thorough understanding of the application requirements.
  • Designing, architecting and developing a highly scalable application.
  • Designing, developing and implementing logic to extract, transform and load data from transactional applications into the Data Warehouse / Databases using ETL Tools and PL/SQL for Business Intelligence projects.
  • Designing and developing the star schema's / DataMart’s that includes creating Fact Tables and Dimension Tables, Views, Materialized views, partitions, Stored Procedures, packages, Functions and Db-Triggers using PL/SQL to implement according to design meeting business requirements.
  • Developing Shell Scripts to schedule Jobs using Scheduler Tools / DBMS Scheduler to execute PL/SQL Stored Procedures and ETL Programs.
  • Writing stored procedures, Functions, Packages. PL/SQL routines, Database triggers, Shell-Scripting, and unit testing integrity.
  • Providing support with complex backend data extraction, transformation and loading operations on oracle using ETL Tools, External Tables, SQL Loader and DATA PUMP utilities.
  • Tuning SQL Queries/ PL/SQL Processes using bulk collections, Hints, Explain Plan, SQLTRACE, and TKPROF for high efficiency.
  • Collaborating with the Quality Analysts and the Business Analysts in an Agile development environment.
  • Providing production support for existing systems, including trouble-shooting, fixing bugs and implementing enhancements.
  • Using version control and code management tools to deploy code/scripts into Test/QA/UAT / Production Environments.
  • Designing and developing integrations using web services (RESTful, SOAP, JSON,XML).
  • Researching and implementing appropriate technical solutions to accomplish strategic direction set forth by the Enterprise Architecture team and IT leadership.
  • Processing Initiate, performing and participating in reviews during the software development life-cycle to ensure proper design/ deve1opment/ implementation of all ETL objects.
  • Following agreed service management guidelines.
  • Creating logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Developing best practices for standard naming conventions and coding practices to ensure consistency of data models
  • Designing, developing, testing, implementing and managing complex ETL processes sourcing data from a variety of internal and external systems such as CAPS. LSS, Artiva, Finance, Taleo, HRMS, etc.
  • Organizing and prioritizing, creating high level plans, setting dates, making commitments and delivering high quality results on time.
  • Designing, documenting, maintaining and publishing data flow diagrams depicting source to target mappings supporting a tiered data architecture comprised of source systems, an operational data store (ODS), data warehouse (DW) and data marts (DM).

 

ETL Data Specialist / Data Stage

  • Design, analysis, Implementation, Testing and support of ETL/ELT framework for complex warehouses/marts.
  • Programs, designs and codes DataStage, Informatica jobs to load fact and dimensional tables as designed for warehouse using Star Schemas, Snow-Flake Schemas Methodologies handling very huge volume of data.
  • Programs data queries, data transformation and loads jobs and data extracts in SQL and PL/SQL using MPP databases.
  • Develop stored procedures, functions, Views and Triggers, Complex queries using SQL Server, TSQL and Oracle PL/SQL.
  • Conducts performance, functional and load-based testing on applications and identifies ways to improve code in ETL Tool.
  • Fine tuning database queries using various tuning techniques.
  • Convert general SQL to compatible with reporting SQL load.
  • Root cause analysis for discrepancies occurring during reconciliation of reports.
  • Develop Logical and Physical Data Models as needed.
  • Design the Enterprise Data Warehouse and appropriate Data Marts.
  • Created data mapping documents and low level/high level ETL design documents.
  • Interact with Customers for requirement gathering, effective analysis and also to provide end-user training.

Apply Online

Attach Resume*

© 2017 All Rights Reserved