SUMMARY:

• ETL Developer with 12 years of experience developing large - scale Data Warehouse and Client/Server Applications, including, Data Migration, Business Process, Design and Development, Integration and Testing, SDLC and Production Support.
• Experience in Retail, Insurance, HealthCare, Banking and Financial domains.
• Experience in complete Software development life cycle (SDLC) with a strong background in implementation of various business intelligence and data warehouse / Data mart projects that cover gathering Business Requirements, Development, Implementations and Documentation.
• Cloud Experience on AWS (DMS, S3, Lambda, RDS, SNS, Cloud Watch)
• Experience in programming Language Python 2.7, 3.7
• Knowledge on Hadoop and Big data technology .
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Talend 7.x, Ab Initio 3.2.x, Informatica Power Centerv 9.x
• Sound knowledge of Relational and Dimensional modeling techniques of DW concepts and principles - Star schema, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
• Experience in integration of various data sources like Oracle, DB2, and SQL Server, Flat Files, and Excel.
• Experience in Performance Tuning techniques to improve the performance for data loads.
• Experience interacting with Business users and Architecting high level requirements, high level design and detailed level design documents.
• Strong Quality Assurance and debugging skills in ETL Process.
• Solid understanding of OLAP concepts and challenges with large sets of data.
• Proficient in Toad, SQL, and UNIX Shell Scripting.
• Created High level Technical Specification, User level requirement documentation and Low level design procedural documents for the ETL process and standards.
• Expertise in Unit testing of mappings, sessions and created documents such as Test Case, Test script document, Test result document.
• Expertise in production support activities like fixing the abends, root cause analysis for recurring abends, working on User queries.
• Involved in helping the reporting team with Business Objects reports and data issues.
• Good knowledge and understanding of Scheduling tool Autosys, CA7.
• Versatile team player with excellent analytical, communication and presentation skills to interact with team members and business users.
• Quick learner and adaptive to new and challenging technological environments
• Excellent communication, presentation, interpersonal skills and leadership qualities.

TECHNICAL SKILLS:

ETL Tools: Talend 7.x, Informatica PowerCenter 9.X, 8.6.1, Ab Initio 3.2.6

Data Modelling: Dimensional Data Modelling, Star Schema Modelling, FACT and Dimensions Tables

Databases: Oracle 9i/8i, DB2, SQL Server

Reporting Tools: BUSINESS OBJECTS XI R2 - Designer, Desktop Intelligence. Trained in Cognos reporting tool

Programming: Python, SQL, Unix Scripts

Cloud: AWS, S3, Lambda

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Create and handle AWS DMS Tasks to migrate data from on premises DB to AWS
• Build Talend jobs to ingest data from different sources into AWS
• Writing Python code in automating different DMS related tasks and putting them in AWS Lambda
• Involved in end user support and bug fixes and tuning the code for better performance.
• Identify, diagnoses, and resolves problems for users and communicates solutions to end-users

Confidential, Atlanta GA

Ab Initio Developer

Responsibilities:

• Work with business clients to deliver strategic and tactical solutions. High quality data is integrated both between internal applications as well as with client's external partners
• Builds ETL components in Ab Initio to address performance, dependency, error handling and data quality issues.
• SQL development and Unix and shell scripting
• Developing Ab Initio graphs for Extracting, Loading and Transforming external data into data mart using components like Reformat, Join, Normalize etc
• Involved in end user support and bug fixes and tuning the code for better performance.
• Identify, diagnoses, and resolves problems for users and communicates solutions to end-users.
• Documents existing process in order to evaluate and define new IT solutions and implementation process.

Environment: Ab Initio 3.2.6, DB2, Oracle, CA7, shell scripting

Confidential

SSIS Developer

Responsibilities:

• Served as SSIS developer taking the ownership of deliverables for all the graphs under 2 LOBs.
• To gather, analyze requirements and mapping, prepare Functional as well as Technical design for one module.
• To advice the changes in design for performance optimization
• To build the SSIS packages for loading the Staging tables from source systems and again loading final tables form these staging tables as per the mappings provided for different source systems involving various Calculations, Default and complex transformations.
• To unit test the code and implement the changes for optimum performance when required.
• To deploy all the packages of 3 LOBs and create the jobs for these packages on SQL server 2005.
• To package and promote the code.

Environment: SSIS, SQL server 2005, Windows, CA7, shell scripting

Confidential

Informatica Developer

Responsibilities:

• Involved in deriving Technical Specifications based on Functional Specifications.
• Developed and tested ETL components using Informatica Power Center .
• Worked on Informatica Designer tools like Source Analyzer, Transformation Developer, and Mapping Designer.
• Involved in creating Tasks, Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Worked extensively on Lookup, Router, Filter, Aggregator, Expression, Stored procedure, Sequence Generator and Update Strategy Transformations.
• Worked with mapping parameters and variables to load data from different sources to corresponding database table.
• Performed testing of the developed components and involved in System testing and UAT support..
• Worked on PowerCenter Versioning (Check-in, Check-out), Querying to retrieve specific objects, maintaining the history of objects.
• Involved in end user support and bug fixes and tuning the code for better performance.

Environment: Informatica Power center 8.1.3, Oracle 9i, PL/SQL, Flat Files, UNIX

Confidential

Informatica Developer

Responsibilities:

• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Prepared documentation such as Functional Specifications document, Technical or ETL Specifications document,
• Worked on Data Analysis, Mapping, Identify Data Quality issues, Data Cleaning, Data validation and Loading.
• Performances Tuning & recommending tuning strategies in Informatica Mappings, Sessions, Workflows and sending automated email on errors, failures, success of the sessions/workflows.
• Expertise in developing and running Informatica Mappings, Sessions/tasks, Workflows, Worklets, and Batch processes on Informatica server.
• Create & Perform Unit & Integration Test Cases, UAT Test Case Review, Migration to Production.
• Involved in creating Tasks, Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Involved in end user support and bug fixes and tuning the code for better performance

Environment: Informatica Power center 8.1.3, Oracle 9i, SQL, Unix

Confidential

Teradata Developer

Responsibilities:

• Developing and testing database queries and SQL tuning.
• Extensive use of Teradata Utilities Multiload and BTEQ .
• Involved in data validation and requirement walk through.
• Developed BTEQ scripts to extract data from the detail tables for reporting requirements

Environment: Teradata and Unix