We provide IT Staff Augmentation Services!

Etl Architecture Resume

Phoenix, AZ

PROFESSIONAL SUMMARY:

  • 10+ years of IT experience in ETL Architecture, Analysis, design, development, testing, implementation, maintenance and supporting of Enterprise level Data Integration, Data Warehouse (EDW) Business Intelligence (BI) solutions using Operational Data Store(ODS)Data Warehouse (DW)/Data Mart (DM), ETL, OLAP, ROLAP Client/Server and Web applications on Windows and Unix platforms
  • Excellent development skillsin informatica power center and cloud components . Developed and deployed complex mappings & workflows.
  • Extensive experience in dealing with huge volume of data.
  • Extensive experience in ETL development in a Greenplum environment using Infromatica, Oracle PL/SQL, Tableau, PERL and UNIX.
  • Thorough knowledge in scd dimensional modelling, table kevel partitions.
  • Expertise in designing and implementing software solution for business requirements using oracle PL/SQL packages, procedures, functions and triggers for data warehouse applications.
  • Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTPapplications.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Identifying performance bottlenecks in applications using Explain Plan and tune long running queries in Oracle by creating indexes, using hints and other techniques depending on the application and query being tuned.
  • Well experienced in UNIX and LINUX shell scripting. Contributed in building the standard framework, common for all data warehouse applications.
  • Seasoned support analyst with proven track record of leading the Fact Sourcing team in delivering/loading the analytical data in Greenplum on or before weekend SLA.
  • Having 3 years of experience on Tableau Business Intelligence/Business Analytics software.
  • In depth knowledge in Quality Assurance. Performed unit testing, regression testing, integration testing and User Acceptance. Assisted Quality Assurance team with software quality testing.
  • Implemented best practices in the project by introducing predefined documentation of standard test cases for critical applications and common test case templates for all applications.
  • Expert in automating jobs using Control - M, CronJobs.
  • Possess excellent problem solving, troubleshooting, communication and team building skills.
  • Have worked in onshore offshore software delivery model. Have played the role of an onsite coordinator.
  • Developed PERL Scripts for Products like ROBII, OBIEE - Tableau Converter and BO - Tableau Converter

TECHNICAL SKILLS:

Operating Systems: Windows 2000/XP/Vista/7, UNIX, Linux

Languages: SQL, PL/SQL

Scripting Languages: Linux and Unix Shell Scripting, Perl

Database: ORACLE 9i and 10g, PostgreSQL, Greenplum, My Sql

Tools: SQL*Plus, SQL Developer, PL/SQL Developer, TOAD, Mercury Quality Centre, Aginity Greenplum Workbench, Putty, DbVisualizer

ETL Tools: Informatica, Informatica Data Quality (IDQ)

Reporting Tools: Tableau, OBIEE

Job Scheduling Tools: Control - M, Cron-job

PROFESSIONAL EXPERIENCE:

Confidential, PHOENIX, AZ

Environment: Informatica Cloud, Powercenter, Salesforce, IDQ, PostgreSQL, Tableau, Python

Responsibilities:

  • Team Lead and interacting with Business Analyst to understand the business requirements. Involved in analyzing requirements to refine transformations.
  • Analysis of the specifications provided by the clients.
  • Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
  • Informatica IDQ development for data integrity, profiling.
  • Created Informatica mappings to build business rules to load data
  • Used Informatica cloud to extract, transform and load data into salesforce.
  • Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
  • Used various transformations like source qualifier, expression, filter, lookup, update strategy, aggregator transformations etc.

Confidential, Palo Alto, Ca

Environment: Informatica Power Centre 9.x, IDQ, Greenplum, Oracle, Control-M, OBIEE 11g, UNIX, Erwin, Tableau

Responsibilities:

  • Preparation of HLD, project plan based on the business functional spec.
  • Informatica IDQ development for Data cleansing, Standardization and deduplication.
  • Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
  • Created Greenplum functions for phasing out existing Informatica mappings. Developed for SCD Type 1, Type 2 etc.
  • Created Informatica mappings to build business rules to load data
  • Used Informatica power center to extract, transform and load data from multiple input sources like Oracle and flat files to target data base Oracle 11g
  • Wrote procedures, packages in oracle as per the requirement.
  • Used mapping designer and mapplets to generate different mappings for different loads
  • Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
  • Used various transformations like source qualifier, expression, filter, lookup, update strategy, aggregator transformations etc.
  • Tuned SQL Queries in Source qualifier Transformation for better performance
  • Designed/developed Stored Procedures for data mappings to implement complex business logics and called from Informatica Stored Procedure Transformations
  • Created triggers, PL/SQL stored procedures and responsible for SQL tuning
  • Wrote the PL/SQL procedures for data extraction, transformation and loading
  • Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
  • Developed a Conceptual model using Erwin based on requirements analysis
  • Developed normalized Logical and Physical database models to design OLTP system for insurance applications
  • Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model

Confidential

Environment: Informatica 9.1, IDQ, Oracle11g, UNIX, Shell scripting, Greenplum, Tableau, Erwin

Responsibilities:

  • Involved in Design/Development activities and delegating work to team members.
  • Maintained track record of all the team activities and posting daily status updates.
  • Used Informatica power center to extract, transform and load data from multiple input sources like Oracle and flat files to target data base Green plum.
  • Used various transformations like source qualifier, expression, filter, lookup, update strategy, aggregator transformations etc.
  • Written complex queries and functions as per the requirement.
  • Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.
  • Involved in performance tuning of sources, targets, mappings, and workflows. Also involved in tuning of SQL queries and PL\SQL procedures.
  • Extensively used Debugger to identify data transfer problems in mappings.
  • Written psql procedures in Greenplum as per the requirement.
  • Analyze the existing OBIEE reports and RPD to prepare the design for Tableau reports.
  • Created sample workbooks, worksheets for data validation in tableau.
  • Involved in Tableau tds creation. Publish the workbooks through tabcmd utility.
  • Extensively worked with Tableau Metadata.
  • Developed a Conceptual model using Erwin based on requirements analysis
  • Developed normalized Logical and Physical database models to design OLTP system for insurance applications
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model

Confidential

Environment: Informatica 9.1, Oracle11g, UNIX, Shell scripting, Perl

Responsibilities:

  • Used Informatica power center to extract, transform and load data from multiple input sources like Oracle and flat files to target data base Oracle.
  • Written shell scripts to extract OBIEE metadata.
  • Create materialized Views.
  • Written PL/SQL stored procedures, functions, packages to parse the metadata as per the requirement.
  • Extensively worked with XML files.
  • Using stored procedures data is loaded into dimensions and facts.
  • Created OBIEE reports on data mart.

Hire Now