We provide IT Staff Augmentation Services!

Sr Etl Consultant Resume

SUMMARY

  • 9+ years of diversified experience in requirements gathering and analysis, design, development, testing and validation in Data centric projects (data bases, data warehousing and business intelligence space).
  • 8+ years of experience with design, development, support and implementation of Data Mart / Data Warehouse applications using Informatica Cloud, Informatica PowerCenter 9.x / 8.x / 7.x components like Designer, Workflow manager, Workflow monitor, Repository manager, Informatica Data Quality (IDQ), Informatica Master Data Management (MDM)) and Microsoft SQL Server Integration Service(SSIS).
  • 8+ years of experience leading small and medium sized Data warehousing and Business intelligence projects and mentoring junior or associate consultants.
  • Strong experience in implementing manual change data capture and delete detection functionality in data warehouse.
  • 2+ years of experience in Informatica administration like installations, configurations, etc. on Informatica PowerCenter (9.x/8.x/7.x) in windows and Linux environment.
  • 2+ years of experience in Cognos 8 BI (8.x, 10.x) - Framework Manager, Report Studio, Query Studio, Cognos connection, Cognos Administration.
  • Proven experience in Full Life Cycle Implementation of Data warehouses.
  • Experience in Dimensional Data Modeling using Star, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling using Erwin.
  • Experience creating ETL objects (mappings, mapplets, sessions, workflows) & Performance Tuning in Informatica
  • Expert in SQL & PLSQL
  • Strong Data cleansing, Data quality, Data archiving and Data/Code Migration experience using Informatica.
  • Extensive working experience in error handling, supporting and scheduling ETL (including production support).
  • Strong understanding and basics in creating jobs and transformations using Pentaho Data Integration (Kettle).
  • Extensive working experience in RDBMS like Oracle 11g/10g/9i/8i, MS-SQL Server, SQL, PL/SQL.
  • Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
  • Expertise in Oracle SQL and PL/SQL (Stored Procedures, Functions, Packages and Triggers) development and SQL Query Tuning for better performance.
  • Developed the audit activity for all the cloud mappings.
  • Highly Skilled with the Integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML files, etc.
  • Good experience in UNIX writing shell scripts, performance tuning on database and Job Scheduling.
  • Skilled in Unit Test, System Integration Test and UAT (preparing test plan, test cases, validation, etc.)
  • Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
  • Ability to architect an ETL solution and data conversion strategy Project experience with developing complex SQL query Project experience with dimensional data model Strong communication skill to work with client
  • Good working knowledge querying and managing changes to Inventory data of Red Prairie WMS.
  • Experience in preparing Project documents, Installation documents and migrations documents.
  • Ability to meet deadlines and handle pressure coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.
  • Sound experience in mentoring/leading a team in Onsite- Offshore model project execution.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.2/9.6.1/9. x/8.x/7.x, Power Exchange, Informatica Master Data Management (MDM), SSIS

Reporting Tools: Cognos BI 10.1/8.4/8.3 , SAP Business Objects Enterprise XI, Desktop Intelligence 12.1.0.914 , Web Intelligence, Universe Designer 12.1.0.914

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005/2000, DB2 UDB 8.1, Teradata

Database Tools: TOAD, SQL * PLUS, SQL Loader, Teradata, Import and Export, Oracle SQL Developer

Data Modeling Tools: Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables, Logical and Physical Data Modeling, Erwin

Languages: PL/SQL, SQL, UNIX Shell Scripting, JAVA, C, C++, HTML

Operating Systems: Windows NT/95/2000/XP/2003/2007, Unix-AIX, Linux

Other Tools: Microsoft Office 2010 (Excel, PowerPoint), WINSCP, PUTTY, FileZilla, FTP, SFTP, SCP, Telnet, Oracle Developer/Designer

PROFESSIONAL EXPERIENCE

Confidential

Sr ETL Consultant

Responsibilities:

  • Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
  • Created mappings for loading data files received from external vendors. Worked with different kinds of input files like CSV, XML, Tab delimited files etc.
  • Created data file cache for improving the performance for lookups.
  • Used hints for suppressing the order by clause in lookup for improving the performance.
  • Used PLSQL stored procedures as part of mappings to improve performance.
  • Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center and Informatica Cloud Real Time(ICRT)
  • Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
  • Developed OLAP applications using Cognos 8BI - (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, and Analysis Studio) and extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units.
  • Responsible for database schema design, extensive T-SQL development, integration testing and other projects that may be necessary to help the team achieve their goals
  • Worked on data cleansing using the cleanse functions in Informatica MDM.
  • Experience in Cloudera Hadoop Eco system
  • Created Mapplet and used them in different Mappings.
  • Enterprise Data Warehouse, OLAP and dimensional data modeling
  • Created Data Replication tasks in ICRT to extract the GUID’s of SalesForce records to enable updates on SalesForce objects.
  • Experience in implementing Data Quality rules on Hive Data sources using Informatica Big Data Edition 10.x
  • Strong analytical skills and SQL proficiency
  • Extensive expertise in Big Data components like tHDFSInput, tHDFSOutput, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tSqoopImport and tSqoopExport
  • Designed several Processes on Informatica Cloud and exposed them as RESTful API services to publish data to external systems.
  • Used sorter transformation and newly changed dynamic lookup
  • Created events and tasks in the work flows using workflow manager
  • Dig deep into complex T-SQL Query and Stored Procedure to identify items that could be converted to Informatica Cloud ISD
  • Developed Performance scripts to ensure Hadoop testing on data.
  • Strong experience in DWH Technologies (Informatica, Netezza, SQL, Unix, Autosys)
  • Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
  • Created Schema objects like Indexes, Views, and Sequences.
  • Developed UNIX Shell Scripts.
  • Developed mappings for policy, claims dimension tables.
  • Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
  • Experience in working with big data Hadoop stack tools like HDFS, HIVE, Pig, Sqoop.
  • Developed shell scripts for running batch jobs and scheduling them

Environment: Microsoft Project, Informatica PowerCenter 9.6.1, 8.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Informatica Cloud,PowerExchange Navigator 9.5.1, Data Explorer (IDE), Data Quality (IDQ), SQL Enterprise Manager 8.0, SQL Server 2005, Oracle 9i/10g, Toad, SQL Developer, MS Access, Cognos 8.3, Tivoli Work Scheduler (TWS) 8.4/8.3, AIX, Sun Solaris & Windows XP/7, PVCS, SCM.

Confidential

Sr Data Warehouse Consultant

Responsibilities:

  • Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
  • Designed Informatica mappings by translating the business requirements.
  • Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
  • Developed reusable Transformations.
  • Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
  • Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
  • Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
  • Prepared SQL Queries to validate the data in both source and target databases.
  • Imported the mappings developed in data quality (IDQ) to Informatica designer.
  • Development of scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using FastLoad, MultiLoad and BTEQ utilities of Teradata
  • Done extensive bulk loading into the target using Oracle SQL Loader.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
  • Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
  • Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
  • Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
  • Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts like PMS and DEA.
  • Involved in the process design documentation of the DW Dimensional Upgrades.

Environment: Informatica Power Center 8.6/7.0 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, TOAD, Erwin 4.0, PL/SQL, UNIX (Sun Solaris)

Confidential

Informatica Developer

Responsibilities:

  • Conducted weekly status calls with business users to understand their requirements about routine maintenance, downtime, code migrations, enhancements, etc.
  • Led the offshore team and onshore team of 2-3 associates to deliver business solutions within the agreed SLA's.
  • Involved in requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process for Sales Data Warehouse.
  • Studied the existing OLTP system(s) and Created facts, dimensions & star schema representation for the data mart.
  • Mapplet and created new mappings using Designer module of Informatica.
  • Modeled the data warehousing data marts in Star join schema.
  • Extensively worked on the performance tuning of the Mappings as well as the sessions.
  • Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions
  • Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Developed mapping to implement Type 2 slowly changing dimensions (SCD).
  • Developed and Implemented Informatica parameter files to filter the data from the source system on a daily basis.
  • Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality
  • Used various debugging techniques to debug the design issues in the mappings.
  • Supported ETL Jobs running mission critical 24*7 systems.

Environment: Informatica Power Center 9.1/8.6.1/7. x, Data Quality, Cognos 8 /10, Oracle 9i, Oracle SQL Developer, SQL server 2005/07, PL/SQL, Flat files, UNIX-AIX 5.1, Linux, Putty, WinSCP 4.3.2, Toad for Oracle 8.6.1, MS-office, MS-Visio, Lotus Notes.

Confidential, Granite City, IL

ETL Developer

Responsibilities:

  • Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, development team members, subject-matter experts and stakeholders to communicate their perspectives with each other, resolve any issues and come to consensus.
  • Conducted weekly status calls with business users to understand their requirements about routine maintenance, downtime, code migrations, enhancements, etc.
  • Coordinated with business users, DBA's, server administrators to implement and migrated business solutions.
  • Participated in Development, deployment and support of database/ETL objects (stored procedures, triggers, etc.) for cast heat, slabs area to populate data warehouse for Steelmaking Process Control Project
  • Participated in user meetings (with business users, analyst and other managers) to understand the business specific requirements
  • Participated in creating test plans, Unit testing and System Integration Testing of the DW objects.
  • Assisted business users in data testing and validation by developing Test plans, Test Cases (negative, positive) and reports (Cognos).

Environment: Informatica 8.x, Oracle 9i/10g, SQL, PL/SQL, UNIX, Cognos 8.3

Confidential

Programmer Analyst

Responsibilities:

  • Participated in requirements gathering sessions and meetings with business users to analyze gather and document new business requirements for new projects or change requests/enhancements to the existing projects.
  • Developed documentation for user requirements
  • Managed and maintained three major in-house database projects namely, Utility Database, Interim, community service tracking system using Microsoft Access, SQL, etc.
  • Developed reports from these data bases as per business requirement to support business decision making of functional managers.
  • Developed test cases and test plans to validate user data and reports to ensure accuracy.
  • Participated in testing, validation and data quality testing.
  • Organized sessions with the business users for user acceptance testing.

Environment: Microsoft Access, SQL, Microsoft Excel, Some custom applications, Windows 2000

Hire Now