We provide IT Staff Augmentation Services!

Etl Lead /sr. Etl Developer Resume

Columbus, OH

SUMMARY OF EXPERIENCE:

  • Over 12+ years of total IT experience in the Analysis, ETL Architecture, Design, Development, Production support, Data profiling, Implementation and Testing of Client/Server and Data Warehousing Applications using Object Oriented Analysis, and ETL Methodologies.
  • Over 12 years of Experience in Data warehousing and business intelligence wif exposure to SQL Server, Oracle 11g/10g/9i, Teradata and Informatica Power Center 10.x9.x/8.x, Power Exchange.
  • 6+ years of experience as Tech/Project Lead, successfully handed offshore - onshore model by achieving all the delivery deadlines.
  • 5+ Years experience and strong background in Agile Methodologies.
  • 3+ Years of experience in Reporting tools Business Objects and Cognos
  • 5+ years of experience of Scum Master
  • 2+ years of experience wif ETL development wif Ab Initio.
  • 3+ years of experience wif ETL development wif Pentaho
  • 1+ Years of experience using ETL tool Data stage
  • Worked extensively in Architecture wif regards to setting up ETL applications in the view of work environment and source code management.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Vastly experienced wif various Databases like Vertica 8.2,Teradata,Oracle 11g/10g/9i, Db2, Sql Server
  • Performed data analysis and data profiling using complex SQL on various sources systems including Vertica, Oracle and Teradata.
  • Efficient in all phases of the software development lifecycle, coherent wif Data Profiling, Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Experience wif Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
  • Monitoring and resolving Data warehouse ETL Production issues.
  • Experience in Visual Studio, UNIX Shell scripting, COBOL, SAS and VSAM.
  • Extensively used Change Data Capture to simplify ETL in data warehouse applications.
  • Automated the jobs using the Scheduling tool Automic, AutoSys, CA7, Tidal and Control-M
  • Efficiency displayed Team-coordination and ensuring customer satisfaction by providing extensive support.
  • Provided production & development support (24X7).
  • Co-ordinate wif Offshore team in all phases and had the responsibility of the onsite has well as offshore Team.
  • Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, sincere, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS:

Data Warehousing Tools: PowerCenter10.x/9.x/8.x, Power Exchange, Data stage, Ab Initio (GDE 1.15/1.14/1.13), Pentaho7.0

Databases: Vertica8.2,Oracle10g/9i/8x/7x,SQLServer2008/2012,Teradata V13.0.,DB2

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and Dimension Modeling Tables, Erwin 4.0/3.5.5,MSVisio

Reporting tools: Business Objects XI 6.5/ Cognos 8.2/8.3/8.4

Testing tools: MTM,WinRunner7.X,QTP, Load Runner, Test Director 8.0/7.x/6.0

DB &Other Tools: USQL, SQL Navigator, VSTS, Toad, SQL* Plus, SQL*Loader, Test Director 8.0, Quality Center, SQL Navigator, Visual Source Safe (VSS), PVCS, Clear Case, Clear QuestProgramming: SQL, PL/SQL, COBOL, JCL, SQL SAS, TSL, HTML, XML,JAVA, C++, C, Unix Shell Scripting, PERL

Job Scheduling Tools: Automic, Control-M, Autosys, CA7 and Tidal

Version Control Tools: Rational Clear Case, PVCS

Operating Systems: Windows 9x/NT/2000/XP, Mainframe, Linux, UNIX, Sun Solaris, HP-UX 10.0.2, IBM-AIX

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ETL Lead /Sr. ETL Developer

Responsibilities:

  • Involved in meeting wif business to gather requirements.
  • Provide technical leadership to other support team members and resolution of technical issues
  • Provide recommendations on database index strategies based on performance metrics
  • Reviewing data models and doing code reviews.
  • Code change migration from Dev to QA to PERF to Production.
  • Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
  • Conduct impact assessment and determine size of effort based on requirements
  • Using the data Integration tool Pentaho Informatica for designing ETL jobs in the process of building Data warehouses and Data Marts.
  • Initiated extensive documentations for the Production Support process improvements.

Environment:Informatica9.5,Pentaho7.0,Vertica,Oracle11g,DB2,Mainframe,Automic,python,MTM,SQL Server, Linux scripting,Cognos

Confidential, Wilmington, DE

ETL Lead /Sr.ETL Developer

Responsibilities:

  • Assessed requirements for completeness and accuracy and determined if requirements are actionable for ETL team
  • Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
  • Working wif stake holders / product owners to prioritize the requirements for sprint.
  • Identified, recommend and implemented ETL process and architecture improvements.
  • Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • formed data analysis and data profiling using complex SQL on various sources systems including Oracle, Sql Servers andTeradata
  • Review and sign off on system requirements, Design documents, Test documents etc.,
  • Created ETL mapping wif PL/SQL procedures/functions to build business rules to load data.
  • Solving the complex ETL logic issues wif our Enterprise Data Services scrum teams using ETL tools like Informatica, Ab Initio.
  • Initiated extensive documentations for the Production Support process improvements.
  • Developed UNIX shell scripts for automation of the process invoking stored procedures.
  • Maintains an excellent relationship wif business users, and customers.

Environment: Informatica 8.6, Ab Initio, Teradata, Oracle11g/10g, SqlServer2008 Control-M, Tidal, Toad, Quality Center, ER Studio, UNIX Shell Scripts

Confidential, Wilmington, DE

ETL Lead/Sr. ETL Developer

Responsibilities:

  • Created the High-Level architecture design documents and ETL frame work design documents.
  • Used Informatica Power Center 8.6 for extraction, transformation and loading (ETL) of data in the data warehouse.
  • Worked in analyzing the issue, trace the problem area, suggest a solution, discuss wif business.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Partitioned the fact tables and materialized views to enhance the performance
  • Improved the performance of the application by rewriting the SQL queries.
  • Establish projects, roles, users, privileges in different ETL environments (DEV, QA, PROD by using Admin console).
  • Involved in data analysis and handling the ad-hoc requests by interacting wif business analysts, clients and customers and resolve the issues as part of production support
  • Initiated extensive documentations for the Production Support process improvements
  • Wrote stored PL/SQL procedures for control processes and certain Business Requirements. Profiled data using Informatica data profiling tool.
  • Designed/Developed unit test plans to test Informatica processes.

Environment:SQLServer2008,Oracle10g,Informatica-PowerCenter8.6,Visio,UNIX,WindowsXP,Erwin, cognosv8 Power Exchange.Toad,Tidal.

Confidential, Saint Louis, MO

Sr.ETL Developer/Programmer Analyst

Responsibilities:

  • Identify the data from both TCS and ICS required to support the operational reporting for the Credit Card Administration group.
  • Analyze the data for completeness and linkages.The sources of the data are: TCS Master from the TCS collections application.TCS Activity from the TCS collections application.
  • Used Informatica Power Center 8.6for extraction, transformation and loading (ETL) of data in the data warehouse.
  • Involved in FTP process to transfer the files from one server to other.
  • Designed/Developed unit test plans to test Informatica processes

Environment: Informatica PowerCenter 8.5 Informatica PowerExchange CDC, Oracle10g and Mainframe,Autosys, SqlServer2005,Toad, QualityCenterv9.0,ER Studio 7.1.1,DB2,Windows XP, UNIX Shell Scripts

Confidential /Syncada, MN

Sr.ETL Developer/Programmer Analyst

Responsibilities:

  • Developed high level technical design specification and low level specifications based on the business requirements.
  • Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) wif business users.
  • Tech Leads will drive all architectural decisions
  • Extensively used Teradata SQL for complex Transformations
  • Extensive use of Teradata Utilities Multiload and BTEQ
  • Involved in creating Data Marts and altering and creating new dimensions and Facts

Environment: Informatica PowerCenter 8.6 Informatica PowerExchange CDC, TeraData,Oracle10g and Mainframe, Autosys, SqlServer2005,Toad, ER Studio 7.1.1,DB2,Windows XP, Quest Central for DB2 v 4.8 UNIX Shell Scripts, Extra X-trame V9, Cognosv8

Confidential, MN

ETL Developer/Programmer Analyst

Responsibilities:

  • Wrote stored PL/SQL procedures for control processes and certain Business Requirements.
  • Created and used parameter files to provide values to the variable used across sessions and workflows of Informatica to reuse wif multiple criteria to decrease maintenance.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
  • Involved developing Shell Scripts for Data validations, PL/SQL procedures and SQL scripts for creating tables, Indexes and for testing the data. Extensively used ORALCE Export/Import Utilities to move the data in between databases.
  • Co-ordinate wif Offshore team in all phases of the project and had the responsibility of team work.

Environment: InformaticaPowerCenter8.6, Oracle9i, SQL, PL/SQL, WindowsXP, Shell Script, FTP, UNIX, Autosys 4.0

Hire Now