ETL Developer/Tester Informatica/Teradata/Unix Shell scripting

Thilakkumar Nataraj

ETL/ Data warehouse/ BI Consultant

**********@*****.*** 425-***-****

Summary:

10+ years of experience in analysis, design, development, implementation and support of Data Warehousing, Reporting and Client/Server applications.

Expertise in Business Requirements Analysis, Application Design, Development, Testing and documentation.

Profound Knowledge of SDLC, DevOps, Agile, Scrum Methodologies

Involved in projects related to Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Comprehensive knowledge and experience in process improvement, data extraction, data cleansing, data manipulation.

Strong expertise in SQL codes through various procedures, functions, and packages/macros to implement the business logics using Oracle and Teradata

Used BTEQ/TPT scripts to load data from staging tables into Target tables.

Strong expertise in developing Unix Shell Scripts

Experience in designing and developing of ETL Routines using Informatica.

Interacted with Stakeholders to gather Requirements/Requests

Strong Knowledge on Migrating the objects using GitHub

Knowledge on Rally Tool and used for tracking projects, efforts and closure.

Knowledge on SAP HANA and supported user queries related to ad-hoc reports.

Expertise in using Informatica PowerCenter 8.6, 9.1, Data Mart, ETL, OLAP, Star/ Snowflake Schema.

Handled Development Teams size of 5. Good at effort estimation and task distribution among the Team members, and overall project coordination.

Education

Bachelor degree in Electronics, Sri Ramakrishna Mission Vidyalaya, India.

Professional Experience

T-Mobile, WA Apr 15 – Current

Lead Analyst

The Project was to implement a single system that can support Financial Subscriber Reporting for multiple billing systems.

1. This system should enable flexible business rules changes

2. Appropriate data processes and controls in line with SOX and other financial reconciliation requirements, from source data to end metric transparency

3. Lay the foundation for Subscriber reporting from the future Converged Charging billing platform.

Various source system will be feeding CSR and provide support for various subject areas and data zones. Several of these source systems feed into a subject area to support the different types of information demand from the business community.

CSR supports existing subscriber activity, usage data report and also supports adhoc reports and BO reports as well.

Responsibilities:

Conducted one-on-one sessions with business users to gather requirements

Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions

Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data Teradata Database systems

Extensively worked on Shell Scripting and Debugging

Support Business user with ad hoc reports and queries

Responsible for Release migration in between different environments.

Maintained SQL scripts, indexes and complex queries for analysis and extraction.

Environments: Informatica Powercenter 9.5.1, Oracle 9i, PL/SQL, Teradata, TOAD, UNIX, Shell scripting, Tidal

Boehringer-Ingelheim, CT Sep 13 – Apr 15

Informatica- Tech Lead

This Project was to build an end to end integration framework that integrates systems of the local Business Units (BU) of BI with Veeva CRM System, i.e. system such as customer master, ERP, digital content and sales/call activity data

Responsibilities:

Analyzed the requirements, functional specifications and prepared Source to Target Mapping document

Created Shell script to validate the source files placed by user and send HTML email with the validation results.

Created Shell script to monitor system space and Used cron utility to schedule the shell scripts

Worked on Performance Tuning of the SQL queries.

Designed and created complex Mappings, maplets using Informatica Designer.

Identified bottle necks in Informatica Source, Transformation, and Target objects and tuned until optimal performance is achieved.

Extensively supported production bug fixes and User training.

Environments: Informatica Powercenter 9.5.1, Oracle 9i, PL/SQL, Teradata, TOAD, UNIX, Shell scripting, Tidal

Lowe’s, NC Nov 12- Sep 13

Informatica Consultant

This Project, Integrated Planning and Execution Program is to provide enhanced efficiency and consistency in the Supply Chain planning processes of Demand Planning and Fulfillment Planning.

Responsibilities:

Working closely with the users in understanding the requirements.

Transforming functional requirements into technical requirements.

Design and develop prototype of conversion engine using Informatica Power center.

Designing of robust conversion engine which accepts data from various legacy source systems and convert the data as per code/decode rules specified by business users.

Involved in fixing defects found in QA and production.

Supported the Production system until system is fully stabilized.

Environments: Informatica Powercenter 9.5.1,Teradata, TOAD, UNIX Shell scripting

JPMC

Informatica Developer Jan 11 – Oct 12

This Project primary focus is to move the data (Global Client Access information details) to the wholesale client business intelligence data so that it can be used in decision making system.

Responsibilities:

Interviewed business partners to determine requirements

Determine scope of projects phases and documented the mappings.

Extensively involved in requirement gathering and Business Analysis using the Use-cases, functional specifications and business rules.

Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.

Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.

Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environments: Informatica Powercenter 9x, Oracle 9i, PL/SQL, UNIX, Shell scripting, Tidal

GE HealthCare

ETL Developer Jun10 – Dec 10

This Project primary focus is to improve/automate the daily task that is being performance by support team and improve the productivity. I have taken this task as my SixSigma Project and successfully executed it.

• Daily Schedule check in Informatica

• Automation on Unscheduling loads for various DB outages

• Exporting objects in Informatica

GE HealthCare

Support Analyst Aug07 – May 10

GEHC uses various technologies in the middleware environment to support multiple business applications throughout the organization that transfers data between different systems. Informatica is used for the batch loads across various source and target systems, generally data related to fulfillment backlogs, Procurements, planning and also interfaces which require secure file transfers are developed in informatica.

Responsibilities:

Administration of infrastructure and users maintenance.

Installation and up gradation of the existing environments to latest version.

Reviewing the architecture of the upcoming interfaces and approving/suggesting changes to align it with standards.

Reviewing the all the changes that are presented in Chance Control calls and analyzing the technical impact to the existing interfaces.

Production deployments of all the new interfaces/changes.

Performing Informatica weekly/monthly server outages and unscheduling loads for any DB outages.

Performing Unix related configuration settings like .profile file creation/changes, SSH configuration between informatica and external servers,gnupg configurations etc.,

Environments: Informatica Powercenter 8X, Oracle 9i, PL/SQL, Teradata, TOAD, UNIX, Shell scripting, Tidal

WORK PERMIT

H1B Visa- Valid Up to April 2019

Contact this candidate