We provide IT Staff Augmentation Services!

Etl Informatica/ Datastage Developer Resume

Dayton, OhiO

SUMMARY:

  • Received Scope award for outstanding contribution as an ETL Informatica Developer towards Confidential HMC EDW Integration Project.
  • “I Appreciate having Bharath on the team very much. He is dedicated to our Projects and Processes. He has been Vital to the success of our team as we have worked with Business partners to complete Company initiatives. Bharath is Good Communicator, Great Teammate and a Pleasure to work with. I enjoy having him on the team - appreciation from Confidential Client Manager.
  • Confidential has 8.5 years of experience in the Information Technology Industry with specific focus on DW&BI Technologies with specialized in DW ETL. As part of his assignments, he has been in Data Analysis, Flow Diagram, Solution Design and Development of Data Warehouse applications on Relational Database (RDMS) using ETL Tools.
  • Expert in working with cross functional teams including Solution architects, Data Management teams, Business Analysts, Quality Assurance and Program Sponsors.
  • Extensively worked on Healthcare: Medicaid, Medicare, Facets, Value Based Program, Claims and Member Data warehouse designs.
  • Demonstrated expertise in Designing, Developing and Deploying Business Intelligence solutions using Informatica, Tortoise SVN and Tidal Process.
  • Experience in Performance Tuning of large/long running Queries thereby optimizing Query execution plan using efficient coding standards.
  • Profound knowledge and ability to write Complex Queries including Correlated Queries with Complex Joins and Aggregate functions and to create Temporary Tables, Views, Indexes.
  • Expertise with DDL and DML statements, RDBM’s data dictionaries, excellent understanding of Relational Database Systems, Normalization, logical and Physical Data modelling for OLTP and Dimensional modelling for OLAP.
  • Experience in enhancing and Deploying the Informatica XML’s from development server to production server by creating the Production Implementation or Deployment Guide.
  • Knowledge in ER Modelling, Star Schema/Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
  • As a team member, have excellent inter-personal and client interfacing skills and the ability to quickly understand technical scenarios and formulate efficient solutions.
  • Outstanding ETL Informatica developing skills coupled with excellent Teradata database skills to facilitate tangible results. Innovative thinker and diagnostic problem-solver, ensures the product development within the agreed project timeframes.
  • Worked throughout the SDLC Life Cycle of a project and contributed the best towards successful execution of the Project. Quick Learner in adopting new tools and work out solutions independently and in leading teams.
  • Hands on Experience in building SSIS packages (.Dtsx) involving ETL Process, Extracting data from various flat files, legacy Systems and Migrating Teradata/Informatica Components into SQL Server.
  • Worked in SDLC Life Cycle and Agile Methodologies in Confidential .

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 8.6, 9.1, 9.6.1 and Datastage 7.5, 9.1, SSIS 2008/2012

Databases & Tools: Teradata, SQL Server 2005, Oracle 11G

Programming Languages: SQL, PL/SQL, UNIX

Scripting Languages: UNIX Shell Scripting

Hardware: Windows 98/XP/2000/2007, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, Ohio

ETL Informatica/ Datastage Developer

Environment: Informatica Power Center 9.1, 9.6, SSIS, Teradata, SQL Server

Responsibilities:

  • Interaction with business team regarding technical and functional requirements.
  • Design and Implementation of ETL Informatica jobs and modifying the existing jobs as per the requirements. Developing delta jobs for transactional and additional data using Informatica Mapping Designer.
  • Scheduling and monitoring the sequences and the flow in Tidal Scheduler.
  • Involved in Performance Tuning of Teradata Queries and Informatica long running jobs by running the Explain Plan and Defining Indexes and Collecting Stats on tables.
  • Testing all the business needs by having Unit and Integration testing techniques.
  • Taking care of Backup Process and Documenting the Backup sequences for Production deployment.
  • Preparing the Production implementation Handover documents for deploying the Database and Informatica Components into INT/CRT/PROD environments.
  • As a Technical Lead Developer, guiding the team with best coding solutions possible and approach with zero or negligible defects.
  • Setting up the environment for Informatica/SSIS ETL Designer, Monitor & Administrator for INT/CRT/PROD deployments.
  • Trained Junior ETL Developers/Interns in Informatica Coding Standards and Code reviewed to meet the Business requirements.
  • Supporting the Business team and walk through the User Acceptance Test results for better understanding.
  • Successfully completed Phase 1 and Phase 2 of the VBR Program.
  • Mentored the team in meeting the Informatica Coding Standards and Performance Tuning the long running jobs to reduce the runtime.
  • Co-ordinate with Application team and Business to generate the Monthly and Quarterly reports for external Provider systems using EDW Data.
  • Effectively Implemented the Error Handling Scenarios for Informatica jobs to succeed though Source data is wrong.
  • Implemented the Attribution Config Engine Automation to reuse the code for future Attribution types.
  • Successfully prepared a plan for VBR Teradata EDW Migration to SQL Server and trained the Junior ETL Developer.

Confidential

ETL Informatica/ Datastage Developer

Environment: Informatica Power Center 9.1, Teradata, Data stage 7.5 & 9.1, Oracle

Responsibilities:

  • Interaction with On-shore Business team and Clients for Technical and functional requirements.
  • Design and Implementation of Informatica and Data stage jobs and modifying the existing jobs as per the requirements.
  • Worked with Cross functional teams and multiple vendors like TCS Testing team for Confidential .
  • Creating PL/SQL queries Procedures and Functions in SQL/Oracle 11G.
  • Created Complex Stored Procedures, Functions, tables, Views, Indexes, SQL Joins and statements for applications by using SQL.
  • Involved in Performance tuning of SQL Queries and Stored Procedures using SQL Profiler.
  • Preparing the Production Implementation Handover documents & Runbooks for deploying the Database and ETL Components into INT/CRT/PRD environments.
  • Testing all the business needs by having Unit and Integration testing techniques.
  • Supporting the Testing team and walk through the Unit testing results and Peer reviewing the QA Test cases to cover all the ETL Scenarios.

Confidential

ETL Informatica/ Oracle Developer

Environment: Informatica Power Center 9.1, 9.6, Oracle.

Responsibilities:

  • Worked with Business Analyst and Business users to clarify requirements and translate the requirement into technical specifications.
  • Responsible for Analyzing, Designing and developing ETL strategies using Informatica.
  • Developed standard and re-usable mappings and mapplets using various transformations.
  • Developed complex Interfaces or Change requests independently by working closely with On-shore Counter parts who sits at client location in California (USA) by understand the technical requisites.
  • Scheduling and monitoring the Job sequences through the Tidal flow.
  • Testing all the business needs by having Unit and Integration testing techniques.

Confidential

ETL Informatica/ BI System Analyst

Environment: Informatica Power Center 9.1, 9.6, Teradata, UNIX

Responsibilities:

  • Liaise with client to gather business requirements, analyze the system impact and identify solutions.
  • Also document the requirements and coordinate with the client for requirements walk-through and sign-offs and ensure that the requirements document accurately portray specific business needs.
  • Based on the Changes recommended by Confidential, who is a part of RIM analysis team, the development team would in corporate the changes in Confidential database, to fulfill the business requirements.

Confidential

ETL Informatica/Teradata Developer

Environment: Informatica Power Center 9.1, 9.6, Teradata, UNIX

Responsibilities:

  • Analysis of Functional documents and Technical Specifications.
  • Writing queries to meet business requirement and developing Teradata BTEQ scripts using Teradata Utilities.
  • Developing BTEQ Scripts to pull data from Source to EDW Target tables.
  • Building Informatica mappings to pull data from Source to Landing/Staging Zones.
  • Involved in Performance Tuning of Teradata Queries and BTEQ Scripts by running the execution Plan and Collecting Stats on recommended tables.
  • Scheduling and monitoring the Informatica/BTEQ Job Sequences using the WLM/Tidal Flow.
  • Testing all the Business needs by having Unit and Integration testing techniques and analyzing the data if found any issue.

Confidential

ETL Informatica/Teradata Developer

Environment: Informatica Power Center 8.6, Teradata, UNIX

Responsibilities:

  • Analysis of Functional Specification documents and creating Technical Specifications for the ETL Flow.
  • Creating Mappings for Target tables using the Flat file source system and performing unit testing.
  • Creating various test cases documents like UTC etc. with Positive and Negative Scenarios.
  • Involved in Performance Tuning of Teradata Queries and BTEQ Scripts by running the execution Plan and Collecting Stats on recommended tables.
  • Scheduling and monitoring the Informatica/BTEQ Job Sequences using the WLM/Tidal Flow.
  • Testing all the Business needs by having Unit and Integration testing techniques and analyzing the data if found any issue.

Confidential

ETL Informatica/Teradata Developer

Environment: Informatica Power Center 8.6, Teradata, UNIX

Responsibilities:

  • Developing Informatica mappings for extraction of data from source files.
  • Preparation of Detail Design document and ETL specification document
  • Involved in Data profiling and Performance Tuning of Teradata BTEQ Scripts.
  • Preparation of Teradata BTEQ scripts using Teradata Utilities based on the Attribute Mapping sheet provided by the Technical Business team.
  • Code review of Teradata BTEQ scripts and providing the comments on performance improvement steps.
  • Unit testing of the BTEQ scripts and Informatica Mappings.
  • Preparation of WLM set up sheet to execute the BTEQ Scripts/Informatica mappings.

Confidential

ETL Informatica/Teradata Developer

Environment: Informatica Power Center 8.6, Teradata, UNIX

Responsibilities:

  • Analysis of Functional documents and Technical Specification documents.
  • Creating documents of ETL Specifications for Informatica/BTEQ Scripts.
  • Developing Informatica Mappings for various tables from source to Landing zones and Unit testing.
  • Involved in Data Profiling and Performance Tuning of Teradata BTEQ Scripts.

Hire Now