We provide IT Staff Augmentation Services!

Etl Designer Resume

Herndon, VirginiA

PROFESSIONAL SUMMARY:

  • 13 years of IT experience with exposure to all phases of software development life cycle (SDLC) includes User Interaction, Business Analysis and Documentation, Data Analysis and Modeling, Solution Design, Development, QA Support, Production Deployment, Production/Customer Support, Maintenance, Enhancements and Quality Control of software
  • Experience of Informatica Power Center and Power Connect products and coding languages. 8 years of development and 5 years of lead/ architect experience in Informatica Power center products
  • Excellent Data Analysis skills and worked as Data Analyst in number of projects
  • Good in data warehousing concepts such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification as well as application design. Worked on Data modeling using the CA ERwin tool as well as the Microsoft Access
  • In depth experience of PL/SQL Development. I have used PL/SQL for a number of processes ranging from performing simple ORACLE Minus operations to complicated calculations
  • Excellent skills writing shell scripts in UNIX and aware of basic UNIX commands. Also, have worked with Informatica specific Unix scripts
  • In depth knowledge of relational database technology and the SQL language.
  • Aware of the syntax and use of MDX Querying language
  • Trained in Confidential TM1 tool, and have used it in multiple projects
  • Worked in projects that implemented ‘Agile methodology’ for design and development process
  • Experience includes implementation of number of Datawarehousing projects as well as Java Applications and Confidential EP based applications to support features needed by users
  • Worked as Developer on projects involving a number of languages like Java, Visual Basic, Oracle PL/SQL, Informatica and Confidential EP as well as Confidential BI, and Teradata Basics
  • Six Sigma Green Belt certified, and part of TCS Process Excellence Group
  • Worked in roles as Technical Architect so have knowledge about documentation of Data Analysis, Documentation of technical design, as well as co - ordination of technical assignments with development team
  • Worked in roles as Business Analyst, and so have knowledge about documentation of Business Requirements, User Interaction, Conduction JAD session organization as well as ‘Sprint meets’ and supporting QA and UAT
  • Involved in the P.M.O (Project Manager’s Office) for quite a few these projects. So have a good knowledge about Client Orientation & Project Assessment, Scoping of project, Budgeting and Resource Allocation.
  • Worked in environments that require development for parallel releases i.e. multiple releases simultaneously. This requiring a robust code management and Scope management process.
  • Possess good communication, interpersonal skills and ability to work in a team as well as individually. I am innovative in Approach and enjoy learning new methods and ideas and putting them into daily practice
  • Performed number of process improvements using Six Sigma methodology

TECHNICAL SKILLS:

Operating Systems: Linux (Red Hat) and Windows

Programming Languages: Java, J2EE, PL/SQL, Visual Basic 6.0, UNIX Shell ScriptingDatabases MS SQL server, Oracle 9i, Oracle 10g, Microsoft Access, DB2, MS SQL server

Application Software: Informatica 8.1.4, CA Erwin, Business Object, Confidential EP, Confidential BI, Confidential TM1, Mercury Quality Center, Toad, SQL Developer, Eclipse

WORK EXPERIENCE:Confidential, Herndon, Virginia

ETL Designer

Responsibilities:

  • Analyze the data in different source systems Acquisition, SIR, MBS Pool, RDW, CE etc; as well as document the data patterns
  • Design the ETL framework process to load the required data attributes in the IDS - Integrated Data Store
  • Design the metadata-based ETL framework for processing event based data and integrating data from multiple events from same and different sources to provide an Integrated view of the data
  • Design the metadata-based ETL solution to integrate data from multiple sources into the IDS - Integrated Data Store
  • Analyze new data patterns and business scenarios related to the patterns and design ETL solutions to process the data
  • Implement Data Model changes in the Oracle Database and complete necessary Stored Procedure changes in the Oracle Database
  • Design and develop framework to vend data stored in IDS to external system ‘CSS - Common Securitization Solution’ using TIBCO
  • Analyze and performance tune the ETL jobs that load data into the IDS and vend the required data to the external platform CSS
  • Develop Data Quality Rules to be implemented in Informatica IDQ
  • Design the JIL file and implement scheduling in Autosys scheduler using Autosys JIL and UNIX scripts
  • Develop UNIX scripts and test the scripts to support scheduling in Autosys and execute Informatica jobs
  • Complete all project related documentation in IBM DOORS tool
  • Provide Deployment documentation in iCART and support deployment of code and provide post-production deployment support

Environment: Power Center 9.6.1, Oracle 11g, PL/SQL Stored Procedures, Autosys Sheduler.

Confidential, Herndon, Virginia

Solution Architect

Responsibilities:

  • Analyze the data in different source systems like the ‘Consolidated Data Store’ and Salesforce
  • Design the ETL process to load the required data attributes in the Multi-Family Data Warehouse
  • Design the metadata-based, Database and ETL framework for Reconciliation
  • Design the metadata-based, Database and ETL framework for Error Handling
  • Implement code in the Informatica ETL Code to process the new data attributes as required, working with the ETL development team
  • Implement Data Model changes in the Oracle Database and complete necessary Stored Procedure changes in the Oracle Database
  • Develop Data Quality Rules to be implemented in Informatica IDQ
  • Design the JIL file and implement scheduling in Autosys scheduler using Autosys JIL and UNIX scripts
  • Develop UNIX scripts and test the scripts to support scheduling in Autosys and execute Informatica jobs
  • Complete all project related documentation in IBM DOORS tool
  • Provide Deployment documentation in iCART and support deployment of code and provide post-production deployment support

Environment: Power Center 9.6.1, Oracle 11g, PL/SQL Stored Procedures, Autosys Sheduler.

Confidential, Weston, Massachusetts

ETL Architect

Responsibilities:

  • Analyze the data in different source systems like the Liquid Hub ODS and Global Commercial Data Warehouse.
  • Design the ETL process to load the different required data attributes in the MS Data Mart.
  • Design the Database and ETL framework for error logging and auditing.
  • Completing performance review of the existing ETL jobs and tune the ETL load process.
  • Implement changes in the Informatica ETL Code to process the new data attributes as required, working with the ETL development team.
  • Implement Data Model changes in the Oracle Database and complete necessary Stored Procedure changes in the Oracle Database.

Environment: Power Center 9, Oracle 11g, PL/SQL Stored Procedures, Windows 2000.

Confidential, Little Rock, Arkansas

Team Lead

Responsibilities:

  • Leading a team of 7 individuals which included Java Developers, Informatica Developers and System Analysts.
  • Analyze the data in CURAM source system, and design the Web services for ‘MEC Update’. The MEC Update service will determine the Medicaid ID for the person once he/she is determined Eligible in CURAM.
  • Prepare the Data model design in Erwin for tables that will store data.
  • Design of ETL Architecture for the data to be loaded from CURAM to the ‘Landing’ tables and from the Landing tables to the Reference schemas and outbound systems.
  • Design and Development of Informatica power center jobs that will provide data from CURAM to the MEC Common Table as well as external systems like the HP MMIS database and the HP OK Medicaid Card Printing Center. Data sent to HP MMIS database and the HP OK Medicaid Card Printing Center via data files.
  • Design and development of code to extract data from Legacy system, ACES; which is a mainframes database and processing the data to the MEC Reference schema.
  • Design and development of cron scripts to schedule Informatica job.
  • Design UNIX shell scripts to process files and also sftp the files to servers out of DIS Network (Department of Information services)
  • Designed ETL process to load the data provided by CMS - Center for Medicare and Medicaid Service; to the systems operated by Arkansas Department of Health Service.
  • Developing Informatica code for web service using web services consumer transformation to integrate the Informatica powercenter with the web service for printing ‘Notices’ for eligible people
  • Implemented Project using Agile methodology, to achieve timely and reliable delivery

Environment: Power Center 9, Oracle 11g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Confidential, Minneapolis, MN

Solution Architect

Responsibilities:

  • Responsible for overall Source system Analysis.
  • Design of the service oriented system involving informatica power center, dot net and MS SQL Server Programmability
  • Data model design in Erwin for tables that store data before transmission
  • Design of ETL Architecture
  • Development of Informatica power center jobs
  • Developing informatica for web service using web services consumer transformation
  • Development of DT (Informatica data transformations) Coding to process xml files into Oracle
  • Implemented Project using Agile methodology, to achieve timely and reliable delivery
  • Development of Espresso jobs to schedule and monitor informatica executions and Stored Procedure executions in Production from Espresso console

Environment: Power Center 9, Oracle 11g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Confidential, Minneapolis, MN

Enterprise Architect

Responsibilities:

  • Responsible for overall Data Analysis.
  • Design of the data loads involving informatica power center, Oracle PL\SQL and MS SQL Server Programmability
  • Data model design in Erwin for tables that store data before transmission
  • Development of Informatica power center jobs
  • Developing informatica for web service using web services consumer transformation
  • Development of DT (Informatica data transformations) Coding to process xml files into Oracle
  • Implemented Project using Agile methodology, to achieve timely and reliable delivery
  • Development of Espresso jobs to schedule and monitor informatica loads, Windows batch scripts and Stored Procedure executions in Production from Espresso console

Environment: Power Center 9, Oracle 11g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Confidential, Minneapolis, MN

ETL Architect

Responsibilities:

  • Responsible for overall Data Analysis.
  • Design of the service oriented system involving informatica power center, dot net and Informatica DT
  • Data model design in Erwin for tables that store data before transmission
  • Development of Informatica power center jobs
  • Developing informatica for web service using web services consumer transformation
  • Development of DT (Informatica data transformations) Coding to process xml files into Oracle
  • Implemented Project using Agile methodology, to achieve timely and reliable delivery
  • Design of portal for ease of business team access to data
  • Leading offshore for development of dot net code for Portal
  • Development of Espresso jobs to schedule and monitor informatica loads, Windows batch scripts and Stored Procedure executions in Production from Espresso console

Environment: Power Center 9, Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Confidential

ETL Architect and Development Lead

Responsibilities:

  • Part of the architecture team responsible for overall System Analysis and service oriented Design, Informatica as well as web portal
  • Data model design in Erwin for tables that store data before transmission, as well of control structures for eCommerce portal control process
  • Writing complicated SQL for views, which extract data from the admin system, as required.
  • Development of Informatica jobs.
  • Development of espresso jobs on the espresso scheduling tool
  • Co-ordination of the development of dot net code for eCommerce portal
  • Review and p performance tuning of all jobs so that the transmission of feed files meets SLA
  • Creation of scripts to run on windows server
  • Development of Oracle and MS SQL Server stored procedures
  • Preparing deployment packages, since deployment was done to production via multiple releases, from Jan 2012 till June 2012
  • Resolution of issues in production, as part of 60 day warranty support
  • Development of Espresso jobs to schedule and monitor informatica loads, Windows batch scripts and Stored Procedure executions in Production from Espresso console

Environment: Power Center 9, Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Confidential, Stamford, CT

Data Warehouse ETL Informatica Architect

Responsibilities:

  • Architect responsible for overall System Analysis, which involved data analysis as well as ETL Job analysis service oriented Design of the architecture that is needed to achieve the CTQ
  • Co-ordinate the implementation of the changes.
  • Analyzing the impact of upgrading to Informatica version 9
  • Review of all SQL Code used in the project for informatica and Confidential for performance tuning.
  • Implemented Project using Agile methodology, to achieve timely and reliable delivery
  • Working as informatica administrator to manage and maintain informatica development and QA repositories.

Environment: Informatica Power Center 8.6 .1., Informatica Power Center 9, Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Confidential Reports.

Confidential, Norwalk, CT

Informatica Development Lead and Architect

Responsibilities:

  • Responsible for overall System Analysis, which included Visual Basic Code and Oracle procedures.
  • Design new system that would use Oracle Database, and Confidential EP as a data entry tool.
  • Creation of ETL jobs for loading data to and from EP Application
  • Writing the ETL Code for generation of Journal Entry file, that was sent to downstream system, for book keeping.
  • Implemented Project using Agile methodology and Scrums, after training in the same, to achieve timely and reliable delivery, which minimizes the changes required after production move
  • Create number of jobs on informatica scheduling to execute and monitor informatica jobs.

Environment: Informatica Power Center 8. 6 .1., Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Confidential Reports.

Confidential, Stamford, CT

Data Warehouse Architect

Responsibilities:

  • Responsible for overall WSS Source system Analysis and Design
  • Analysis of impact of WSS changes on the Data Warehouse
  • Worked towards creating an automated reconciliation mechanism, using ORACLE Minus, that matches data between the WSS version 7.2.26 and version 7.3.13
  • Worked towards creation of a deployment plan, for the Upgrade, with zero downtime.
  • Analysis and ETL implementation of the new parameterized logic for aggregating cash flows from WSS, after applying event based logic on the data.
  • Acting as reviewer of ETL code to check if code has followed standards and is performance tuned
  • Review of Confidential BI queries to check if data model is accurately utilized and query is optimized and suggest changes in data model if needed.
  • Working as informatica administrator to manage and maintain informatica development Repositories.
  • Implemented LDAP access for users on the informatica repository

Environment: Informatica PowerCenter 8.5.1., Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Confidential Reports.

Confidential, Stamford, CT

ETL Architect and Development Lead

Responsibilities:

  • Worked with Data Architect for Data Analysis and creating Data Mapping Specifications.
  • Created ETL Design documents and Data Flow Diagrams.
  • Designed the ETL and ELTL Jobs for nightly batch loads that will process and aggregate data as needed by the Tax users. These included PLSQL jobs as well as Informatica jobs.
  • Designed ETL strategy for Daily Intraday loads that were needed at Quarter ends to provide data to the users as soon as possible.
  • Worked to develop queries to extract data from Data Warehouse for Confidential BI Reports
  • Reviewed the SQL and PL/SQL Code as well as the informatica jobs and suggested points for performance tuning of the ETL Jobs.
  • Worked closely with Business analysts to ensure the correct processing of data.
  • Create number of jobs on informatica scheduling to execute and monitor informatica jobs.

Environment: Informatica PowerCenter 7.1, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Confidential Reports.

Confidential, Norwalk, CT

ETL Analyst Programmer

Responsibilities:

  • Analysis of the time consumed by the ETL process and bottlenecks in the current ETL process. The analysis was done using Informatica Data Analyzer tool.
  • Worked to come up with documentation and guidelines for the performance tuning of ETL jobs so that data can be available to the Business users as soon as possible.
  • Documented a number of steps that needed to be implemented in Informatica, as well as at the database and in Infrastructure to improve the performance of the nightly batch window. These also included architectural changes in the ETL process as well as using various features of Informatica and the Oracle database.
  • Implemented the road map set up in close co-ordination with the Infrastructure team and the QA team.
  • Working as informatica administrator to manage and maintain informatica development and sandbox repositories.
  • Create number of jobs on informatica scheduling to execute and monitor informatica jobs.

Environment: Informatica PowerCenter 7.1, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Confidential Reports.

Hire Now