We provide IT Staff Augmentation Services!

Bi Developer Advisor Resume

Atlanta, GA

PROFESSIONAL SUMMARY:

  • Over 9 years of professional IT experience in Data warehousing, Design, Development, Analysis, Implementation, Maintenance and testing.
  • Excellent knowledge in data warehouse development life cycle, dimensional modeling, and implementation of star, snowflake and slowly changing dimensions.
  • Experience working in Banking, Retail,, Insurance and Healthcare domains.
  • Extensive hands - on expertise using Informatica Power Center 9.x/8.x/7.x versions along with Informatica DVO.
  • Experience working on xml and web services using Informatica Power Center.
  • Experience working on ETL and ELT data from various heterogeneous source systems like Netezza, Hadoop, Oracle 11g/10g, SQL Server 2008/2005, Teradata, DB2 10, Flat files, Teradata, SAP R/3 into Data Warehouses and Data Marts using Informatica Power Center.
  • Experience using Sqoop and Teradata connectors (TDCH) to export data into Hadoop from Teradata.
  • Expertise in Performance Tuning (Query tuning, Informatica dynamic session partitioning for optimal performance).
  • Experience in Production Support and On-Call support.
  • Worked under Agile-SCRUM and Waterfall model methodologies.
  • Excellent communication skills with emphasis on presentation and developing strong interpersonal relationships.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 7.1/8.1/8.6/9.6

Data Quality Tools: Informatica Data Quality

ETL Testing Tools: Informtica Data Validation Option (DVO)

Databases: Teradata V2R5/V2R6/V12, Netezza 4.5.4/4.6.8, SQL Server 7.0/2000, Oracle 8i/9i/10g, DB2 8.0, MS Access

Languages: UNIX shell scripting, Perl scripting, BTEQ, PL/SQL.

Reporting: Business Objects, Tableau

Scheduling tools: Control-M, CA Workstation (ESP), MAESTRO, Skybot

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

BI Developer Advisor

Responsibilities:

  • Develop end-to-end ETL process modules for the project, which involves extracting data from source file, pre-processing which includes data validation and cleansing, apply business rules as per the requirements.
  • Worked in Agile environment and used JIRA to track the tasks and for daily status updates.
  • Used Informatica Power Center, UNIX shell script, BTEQ (T-SQL), Complex SQL queries for building and supporting day-to-day ETL processes.
  • Extracted data from Teradata and loaded into DataMart’s, residing on Teradata and also to other downstream applications, residing on Hadoop.
  • Improved performance by optimizing and tuning database objects and ETL processes.
  • Build end-end workflow management ETL processes using CTRL M, interact with PRC and Domain OPS team for building the schedules.
  • Worked on defect remediation projects; primarily involved in defect analysis, solution scoping, and solutions design.

Environment: Informatica Power Center 9.6.1, Teradata, Hadoop, SQL Server 2012, UNIX, Control-M, JIRA.

Confidential, Columbus, OH

ETL Developer/Lead

Responsibilities:

  • Worked in an agile environment that facilitated to play different roles during the course of the project.
  • Developed end-to-end ETL process modules for the project, which involves extracting data from source file, pre-processing which includes data validation and cleansing, apply business rules as per the T2S document, processing data for date chaining and then loading into facts and dimensions. Working knowledge on data vault architecture and hybrid modeling concepts.
  • Used Informatica Power Center in combination with Unix and sql for day-to-day ETL operations.
  • Extensively worked on complex Informatica transformations such as xml parser, xml generator and web service consumer transformations.
  • Used TDCH to export data over to Hadoop in Avro and create Hive tables for further downstream processing.
  • Used SOAP UI to test the web service functionality.
  • Built end-end workflow management process using ESP scheduling tool.
  • Invoked web service calls via Informatica using web services consumer transformation to update customer details at client system.
  • Extensively used mapping parameters, variables, session variables, workflow variables and parameter files.
  • Implemented SCD methodology including Type 1 and Type 2 changes to keep track of historical data. Worked extensively with UNIX in creating shell scripts and Informatica parameter file.
  • Involved in post production support.
  • Used Harvest to implement change management process and to move the code across environments.

Environment: Informatica Power Center 9.5.1, Netezza, Oracle, Teradata, UNIX, Ruby Mine, Linux, HP Quality Center, CA work station (ESP), Harvest

Confidential, Scottsdale, AZ

ETL Developer

Responsibilities:

  • Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
  • Developed technical specification document of the etl flow.
  • Created various Informatica mappings to extract data from SAP transparent tables and load into legacy systems (AS400) and also to ODS, to support reporting functionality for micro strategy.
  • Extract data from AS400 files and load into SAP IDOCS, which are intermediate documents in SAP system.
  • Extensively used Informatica power center components and also mapping parameters, variables, session variables, workflow variables and parameter files.
  • Improved performance by optimizing and tuning database objects and ETL processes.
  • Experience working on pre and post session commands to call batch scripts and also to send email notifications.
  • Created reusable transformations and mapplets.
  • Created and scheduled workflows using Informatica scheduler.
  • Performed code review of the etl code, validating it against the requirements.
  • Performed code migrations to higher environments using deployment groups.
  • Used Informatica DVO to perform unit testing and Involved in Integration, system, and performance testing levels.
  • Preparing, executing and documenting Unit Test Cases. Providing full support during SIT and UAT phase.
  • Prepared production monitoring and support handbook for ETL Process.

Environment: Informatica Power Center 9.1, Informatica DVO 9.5, SQL Server 2008 R2, SQL Server Management Studio, I Series Navigator, SAP R/3, DB2, Windows, HP ALM.

Confidential, Glendale, AZ

Informatica Developer

Responsibilities:

  • Involved in all phases of SDLC from requirements gathering, analysis, designed functional specifications and technical specifications, unit and integration testing and implementation.
  • Used Informatica Power Exchange for Change Data Capture (CDC).
  • Developed complex Informatica mappings and tuned them for better performance.
  • Implemented Aggregator, Filter, Joiner, Expression, Lookup and Update Strategy, Normalizer, Sequence generator transformations, lookups.
  • Implemented Error Handling Logic which involves testing of incorrect input values for the mappings and the means of handling those errors.
  • Developed Workflows containing different Tasks like Worklet’s (Both Reusable and Non-Reusable), Session, Decision, Assignment, Control) during final Phase of the Project.
  • Implemented SCD methodology including Type 1 and Type 2 changes to keep track of historical data.
  • Responsible for improving query and session performance. Used session partitions, dynamic cache memory, and index cache to improve the performance of Informatica server.
  • Extensively used Quality Center to keep track of and work on any defects created as part of projects or any production outages

Environment: : Informatica Power Center 8.6, Oracle, SQL Server, DB2, UNIX, Informatica Power Exchange

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

  • Used Informatica Power center to extract/transform and load data into different systems involving Oracle, Sql Server and Flat files.
  • Developed Informatica mappings using transformations like Joiner, Lookup, Router, Filter, Normalizer, Union, Sequence Generator, Aggregator and Expression.
  • Provide Support to Golden Gate process in production and QA environment.
  • Fine tune production ETL code and database queries to improve the performance and reduce the run time to meet the SLA.
  • Worked on Production service desk tickets and Incidents to resolve any production emergency issues that need an immediate fix in order for the flows to complete
  • Implemented Error handling and Exception handling in Informatica Mapping Designer
  • Worked with the business to resolve data quality issues.
  • Support smoke testing and code verification after deployment and Coordinate with the testing team for System testing.

Environment: Quality Centre 10, Informatica Power Center 9.1.1/8.6.1, Oracle 10g, Teradata, UNIX, HPSM, SQL Server

Confidential, Milwaukee, WI

ETL Developer

Responsibilities:

  • Involved in all phases of SDLC from requirements gathering, analysis, designed functional specifications and technical specifications, unit and integration testing and implementation
  • Developed transformation logic and mappings in Designer.
  • Extracted Data from various sources like Oracle and Netezza and flat files.
  • Used ODBC to connect to the target Oracle and Netezza database.
  • Worked with various active & passive transformations.
  • Extensive Use of SQL Overrides and substituted them in place of multiple transformations.
  • Extensive use of connected and unconnected lookup Transformations.
  • Implemented Aggregater, Filter, Joiner, Expression, Lookup and Update Strategy, Normalizer, Sequence generator transformations
  • Developed complex Informatica mappings and tuned them for better performance.
  • Developed Reusable Mapplets and Transformations for complex calculations.
  • Implemented Error Handling Logic which involves testing of incorrect input values for the mappings and the means of handling those errors.
  • Developed Workflows containing different Tasks like Worklet’s (Both Reusable and Non-
  • Reusable), Session, Decision, Assignment, Control) during final Phase of the Project.
  • Implemented SCD methodology including Type 1 and Type 2 changes to keep track of historical data.
  • Created user-defined variables which were part of the workflow/worklet’s link condition, used inbuilt variables as part of the conditions like target rows etc with Informatica.
  • The data was sourced from legacy systems and vendor Oracle databases. Worked on production tickets that need to debug and fix PL/SQL adhoc reporting queries.

Hire Now