SUMMARY

• Overall 8+ years of experience in the field of Information Technology working for Healthcare, Financial, Banking and Waste Management domains.
• 6+ years of exp in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Lineage, Data Integration, Master Data Management (MDM), Metadata Management Services, Reference Data Management (RDM).
• 3+ years of experience in ETL Design, Development, Maintenance, Enhancements and Production Support which includes Data Analysis, Data Profiling using ETL tools like Talend / Informatica.
• Extensive domain knowledge in Investment Banking, Retail and Technology, Insurance and Healthcare,
• Good knowledge in IBM DataStage Designer & Director Clients. Currently migrating / rewriting DataStage, SSIS & Salesforce DBAmp Jobs to Talend.
• Experience in working with Data Warehousing Concepts like OLAP, OLTP, Star Schema, SnowFlake Schema, Logical Data Modelling, Physical Modelling and Dimension Data Modelling.
• Good experience on Oracle, Teradata, MS SQL Server, Amazon S3, Redshift.
• Good knowledge on Informatica Client tools like Designer, Workflow Manager, Workflow Monitor.
• Good experience on Informatica (MDM) Master Data Management tool.
• Trained on TICBO Business Studio for Business Works
• Worked with Pre - Session and Post-Session UNIX scripts for automation of ETL jobs using ControlM/AutoSys scheduler and Involved in migration/conversion of ETL processes from development to production environment.
• Extensively worked on Error logging components like tLogCatcher, tStatCatcher, tAssertCatcher, tFlowMeter, tFlowMeterCatcher.
• Used Talend most used components like tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more
• Manage Agile Project Dashboards & Burn down Charts in JIRA tool.
• Extracted data from multiple operational sources for loading into staging area, Data warehouse, Data Marts using SCDs (Type 1/Type 2/ Type 3) loads.
• Experience in writing PL/SQL stored procedures, triggers, functions and tuning complex SQL queries.
• Experience in utilities like SQL*Loader, TOAD for transferring data.
• Extensively worked on Talend Bulk components for different data bases.
• Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc.
• Working experience with job scheduling tools like Autosys, Control- Confidential, TAC, CRON scheduler.
• Worked extensively on the modelling tools like Erwin data modeler and Microsoft Visio.
• Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
• Good experience in writing complex queries using JOINS, Subqueries, Correlated Subqueries, PL/SQL procedures, functions, triggers and cursors. ­­­
• Experienced in scheduling the ETL jobs on daily, weekly, monthly and yearly basis in the Execution plan in TAC using the CRON trigger.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in writing/documenting Technical Design Document (TDD), Functional Specification Document (FSD), Test Plans, GAP Analysis and Source to Target mapping documents.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Strong expertise in ETL, Data warehousing, Operational Data Store (ODS), Data Marts, Data lake, OLAP and OLTP technologies.

TECHNICAL SKILLS

Programming: C, C++, R, Python, Java

Databases: SQL Server, MS Access, Oracle, Teradata, RedShift

Visualization Tools: Tableau, QlikView

Methodologies: Agile, Waterfall

Markup languages: XML, HTML, DHTML, XSLT, XPath, XQuery and UML

ETL Tools: Talend, DataStage, DBAmp, Informatica Power Center, SSIS

Integration Tools: Tibco Business Works

Modeling Tools: MS Visio, Erwin, Rational Rose

Testing Tools: HP Mercury Quality Center ALM, QTP

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Talend ETL Developer

Responsibilities:

• Transform existing ETL logic on DataStage, DBAmp & SSIS applications into Talend Open Studio for Data Integration Platform
• Understanding existing DataStage Jobs and need to build Talend Jobs accordingly.
• Designed various jobs for extracting data from various sources involving flat files and relational tables.
• Creating Talend ETL jobs for Data Services with Talend Open Studio (Version: 6.5 .1) Using ETL methodologies and best practices
• Worked with Data Mapping Team to understand the source to target mapping rules.
• Identifying, analyzing, and interpreting trends or patterns in complex data sets.
• Implemented the changes that to be made according to Change Requests in existing developed jobs and implemented Error Handling to provide the detailed error messages.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Development of Individual & Batch Jobs in Talend and Tibco BW and Design, develop, validate and deploy the Talend ETL processes to the Oracle Data Warehouse (ODW).
• Used Talend Troubleshooting and Data stage to understand the errors in Jobs and used the tMap/expression editor to evaluate complex expressions and look at the transformed data to solve mapping issues.
• Working closely with subject matter experts (SME’s) to help design and build solutions for a multitude of applications, including batch processing, OLAP and data warehouse architecture.
• Writing Complex SQL Queries, SQL Tuning, Stored Procedures as per Oracle Data Warehousing best practices.
• Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.
• To run sub jobs in parallel, used tParalleize component and multi thread execution. These components are useful to increase job performance.
• Sourcing data from AWS S3 buckets and further loading it into Redshift, SQL Server, MySQL
• Used various Talend components like tMap, tJavarow, tjava, tSqlRow, tMSSQLInput, tStatsCatcher, tDie, tLogrow, tMap, tDie, tConvertType, tLogCatcher, tRowGenerator, tHashInput & tHashOutput
• Perform Data Analysis and create Source to Target mapping document, including business logic (data rules) and performing technical analysis, design, development, testing, and deployment of IT solutions as needed by business or IT.
• Extracting data from various databases such as Microsoft Sql Server Management Studio (SSMS), Teradata and Oracle
• Expertise in Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis.
• Developed jobs using Talend for data loading, importing Source/Target tables from the respective databases and flat files.
• Designed and Implemented ETL for data load from heterogeneous Sources like Salesforce and multiple files on weekly and quarterly basis to target databases for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2 to capture the changes
• Creation of UNIX scripts and testing of existing Autosys jobs to automate the process.
• Prepare functional, technical design documentation for application development
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components
• Perform Unit and Integration testing on ETL code for production release

Environment: Talend 6.5, Tibco BW 6.5, Oracle 12c, PL/SQL, Agile, JIRA, ETL, DataStage. SSIS, MS SQL Server, SQL Developer, Redshift, WinSCP, FileZilla, OLAP, OLTP, Remedyforce, Gitlab, Crontab, SourceTree, Putty

Confidential, Scottsdale, AZ

Informatica Data Analyst / Jr ETL Developer - Master Data Management (MDM)

Responsibilities:

• Worked closely with Business Analysts to review the business specifications of the project and to gather the ETL requirements
• Perform technical analysis, ETL design, development, testing, and deployment of IT solutions as needed by business or IT.
• Designed ETL process using Talend Tool to load from Sources to Targets through data Transformations.
• Created complex mappings using tHashOutput, tMap, tHashInput, tDenormalize, tUniqueRow. tPivotToColumnsDelimited, tNormalize etc.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Created Context Variables and Groups to run Talend jobs against different environments like Dev, Test and prod.
• Developed error logging module to capture both system errors and logical errors that contains Email notification and moving files to error directories.
• Develop ETL mappings for various Sources (.TXT, .CSV, .XML) and load the data from these sources into relational tables with Talend Enterprise Edition.
• Created, debugged, and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Developed and executed UNIX scripts for execution of ETL.
• Everyday Capture the data from OLTP Systems and various sources of XML, EXCEL and CSV and load the data into Talend ETL Tools.
• Efficient in writing complex Java code using tJava, tJavarow, tJavaFlex and handled Heap Space Issues and memory related issues in Talend.
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Confidential, Charlotte, NC

Informatica Data Analyst - Master Data Management (MDM)

Responsibilities:

• Analyzed the business requirements by dividing them into subject areas and understood the dataflow within the organization.
• Performed data analysis and data profiling using complex SQL queries on various sources systems including Oracle and SQL Server.
• Created, documented and maintained, Technical Design Documents (TDD), Logical Base Data Model and Physical base Data Model documents in compliance with enterprise standards.
• Performed data reconciliation, GAP Analysis between Source (Sql Server) and Target (Oracle) Systems.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like MS Visio, Excel and SQL.
• Extensively used MDM 10.2 Hub Console to document various processes as per business needs.
• Maintained / Custodian for all the artifacts related to EPIC (Enterprise Party Identification and Consolidation) 2.0.
• Created 5 Run books for post-production support implementation and presented to the Vice President, Program Managers, Project Managers, Developers and other Business teams.

Environment: Informatica Power Center 10.2, Informatica MDM, Oracle 11g, Teradata, PL/SQL, Agile, JIRA, ETL, SSIS, MS OLAP, OLTP, Remedyforce, Gitlab, Crontab, SourceTree, Putty

Confidential, Wilmington, DE

Sr Data Analyst - Master Data Management (MDM)

Responsibilities:

• Expertise in translating business requirements into feasible technical ETL specifications, identifying key deliverables and defining timelines from an Enterprise perspective.
• Extensive experience in Data Warehousing using Informatica PowerCenter with expertise in design, development and implementation of Extraction, Transformation and Loading processes.
• Developing Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management (MDM) Architecture involving OLTP, ODS and OLAP.
• Transformation on the files received from clients and consumed by Sql Server.
• Involved in defining the source to target data mappings, business rules, and data definitions.
• Performing data profiling on various source systems that are required for transferring data to ECH using Informatica Analyst tool 10.1/9.6.1.
• Extensively worked on source to target mappings to perform initial, full, and incremental loads into the target data mart.
• Performing Data Profiling, Cleansing, Integration and extraction tools (e.g. Informatica).
• Working closely with the SSIS, SSRS Developers to explain the complex Data Transformation using Logic.
• Defining the list codes and code conversions between the source systems and the data mart using Reference Data Management (RDM).
• Utilizing Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for Data Profiling.
• Performing an end to end Informatica ETL Testing for these custom tables by writing complex SQL Queries on the source database and comparing the results against the target database.
• Using HP Quality Center v 11 for defect tracking of issues.
• Extracting the source data from Oracle tables, MS SQL Server, sequential files and excel sheets.
• Developing and maintaining Data Dictionary to create metadata reports for technical and business purpose.
• Collaborating with BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Applying data cleansing/data scrubbing techniques to ensure consistency amongst data sets.

Environment: MDM 10.2, Informatica Analyst 10.1/9.6.1, ETL, Power Center 9.x/8.1, MS Excel, MS Visio, Agile, Sql Server, Cognos, Oracle, Meta Data, IDQ, IDD, UNIX, T-SQL, HP Quality Center ALM 11, RDM (Reference Data Management), Data Governance, Data Lineage

Confidential

Business Analyst

Responsibilities:

• Acted as primary liaison between the clients and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process Modeling.
• Reviewed Development Plans, Quality Assurance Test Plans and User Documentation to ensure correct interpretation of original specifications.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Matrix.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Wrote T-SQL statements and stored procedures in Sql Server Management Studio for extracting as well as writing data.

Environment: Microsoft Office, Rational Clear Case, XML, MS Visio, MS Excel, MS Access, Manual Testing