LATHISH DS

Email: adctwu@r.postjobfree.com

Mobile: 91-961*******

Professional Summary

●Having 3+ Years of experience in developing and implementing the Data warehousing applications using Informatica, DataStage, DB2, Oracle and UNIX.

●Good experience in ETL process and fulfillment of Data warehouse project tasks such as data extraction, transforming and loading into the target database.

●Extensively used various client tools like Designer and Director While developing and debugging the DataStage Jobs.

●Extensively worked on Transformer, Lookup, Join, Datasets, Sort, Aggregator, Funnel and Sequential File and Oracle connector stages.

●Having hands on experience in code design and development using Informatica ETL tool.

●Having hands on experience in scheduling tool like CA Work Station for scheduling the data stage jobs and also ETL Job Controller for passing parameters at run time and checking the errors.

●Worked on production deployment of data stage jobs using Jenkins and Udeploy tool.

●Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative Knowledge to provide accurate software solutions.

●Having knowledge on Data warehousing concepts, Oracle and UNIX Shell scripting.

●Having Knowledge on Python.

●Have good analytical, programming and problem solving skills with excellent interpersonal skills, and a good team player.

●Effective interpersonal communication, listening and coordination skills. Strong experience in a client facing role also involving management of customers work request at senior level.

Professional Experience

●Currently working for Tata Consultancy Services from Apr-2019 to Till date.

●Worked as Data Stage Developer in IBM India Pvt. Ltd from Jan- 2017 to Mar-2019.

Educational Qualifications

●B.Tech in Computer science & Engineering from Sri Venkatesa Perumal College of Engineering and technology in the year 2015 from Jawaharlal Lal Nehru Technical University (JNTU).

Technical Skills

ETL Tools : IBMDataStage9.5 and11.7v,11.2/11.5v, Informatica

Databases : Oracle,DB2,Teradata

Languages : SQL, PLSQL

Scheduling Tool :CA Work Station, Job Control

Operating System : Windows XP/ 7, UNIX, Shell Scripting.

Project Profile:

Project # 1

Project Name : CIGNA

Domain : Health Care Services

Environment : DataStage 11.7V, Oracle/DB2/Teradata, UNIX

Role : ETL Developer

Period : From April 2019 to till date.

Description:

Cigna is an American worldwide health services organization based in suburban Bloomfield, Connecticut and Philadelphia, Pennsylvania. Its insurance subsidiaries are major providers of medical, dental, disability, life and accident insurance and related products and services, the majority of which are offered through employers and other groups (e.g. governmental and non-governmental organizations, unions and associations). Cigna is incorporated in Connecticut.

Responsibilities :

●Developed ETL Jobs to extract the source data and load into the enterprise data warehouse after cleansing, transforming and integrating using data Stage .

●Involved with Requirement’s team and architects to understand the flow of the project and requirements to design the code.

●Developed job sequences to execute a set of jobs with restart ability, check points and implemented proper failure actions like mail notifications etc.

●Worked on Stored Procedures for ETL process.

●Worked on troubleshooting, performance tuning of code both in Data Stage and SQL.

●Worked on enhancements as per customer requirements.

●Having hands on Scheduling tool like CA Work Station and Job Control for monitoring and scheduling the DataStage Sequencer jobs.

●Extensively used Sequential file, Unstructured, Db2, Oracle connector, remove duplicate, join, Funnel, Sort, Aggregator, Transformer while developing DataStage jobs.

●Involved in Unit Testing. Responsible to check test cases.

●Supported SIT, UAT and Production deployment.

Project # 2

Project Name : MIS REPORTING

Domain : Finance

Environment : DataStage 11.5V, Oracle/DB2/NETTEZA, UNIX

Role : ETL Developer

Period : From Oct 2017 to Mar 2019.

Description:MIS (Management Information System) is a project falls under EMEA. Our team, Business Analytics and Optimization team, is responsible to make and generate the reports for making the strategies on increasing the Revenue, Utilization, Cost and Market growth for the enterprise.

Responsibilities :

●Understanding the Functional requirements and preparing the Interface design documents.

●Developed ETL processes to extract the source data and load into the enterprise data warehouse after cleansing, transforming and integrating.

●Involved with Requirement’s team and architects to understand the flow of the project and requirements to design the code.

●Developed job sequences to execute a set of jobs with restart ability, check points and implemented proper failure actions like mail notifications etc.

●Created reports for job statistics and validation summary report

●Worked on troubleshooting, performance tuning.

●Developed the DataStage jobs as per the design document.

●Used DataStage sequencer jobs extensively to control DataStage jobs.

●Responsible to run the developed jobs through ETL control environment.

●Extensively used Sequential file, Unstructured, Db2, Oracle connector, remove duplicate, join, Funnel, Sort, Aggregator, Transformer while developing DataStage jobs.

●Involved in Unit Testing. Responsible to check test cases.

●Supported SIT, UAT and Production deployment.

Project#3

Project Name : ANIRA (AT&T Network-Based IP VPN Remote Access Services)

Domain : Telecom

Environment : Datastage8.5/9.5v, Oracle/DB2, UNIX

Role : ETL Developer

Period : From Jan 2017 to Oct 2017.

Description:

AT&T is an American multinational telecommunications corporation, headquartered at Whitacre Tower in downtown Dallas, Texas. AT&T is the second largest provider of mobile telephone and the largest provider of fixed telephone in the United States, and also provides broadband subscription television services. AT&T is the third-largest company in Texas (the largest non-oil company, behind only ExxonMobil and ConocoPhillips, and also the largest Dallas Company). As of February 2017, AT&T is the 12th-largest company in the world as measured by a composite of revenues, profits, assets and market value, and the 12th-largest non-oil company. As of 2017, it is also the 18th-largest mobile telecom operator in the world, with over 135 million mobile customers.

Responsibilities:

●Worked on the various layers of Staging to DW/Prep, Dimension and implemented the design/code changes for the existing design/code.

●Involved in working on the new framework design Anchor design implementation which reduced the parking concept at staging to DW layer.

●Involved in writing queries for the retro-feed jobs to reprocess the rejected records which have been parked during staging to prep/DW layer.

●Applied business transformations in DataStage jobs/SQL queries as per the given requirements.

●Designed and implemented SCD (Slowly changing dimensions) and Change Capture methodologies.

●Gained complete knowledge/expertise on the process, methods and the tools which are being used within the project.

●I have written and executed test cases for Data validation as a part of SIT regression

test.

Contact this candidate