SUMMARY:

• 16 years of experience in system analysis and design in all phases of SDLC with emphasis on Data Warehousing and Informatica as ETL tool well versed in ETL and ELT process
• 10 years of experience in USA and 2 in Belgium, 8 years of experience in leading a team size of 12+ in offshore/onsite environment
• 10 years of experience working with Informatica PowerCenter ETL tool
• 1 - year experience in Informatica Intelligent Cloud Services (IICS) and Informatica Cloud real time event-based services also completed IICS 101/201
• 1+ Year of experience in Informatica Analyst and Informatica Data quality (IDQ) for profiling and cleansing
• 2 years Informatica B2B data transformation studio
• 2 year of experience using Informatica Power Exchange
• 3 years of experience using XML technologies like XML, XSD, XSLT, XQuery also familiar with JSON
• Hands on experience in performance tuning of mapping, identifying and resolving performance bottlenecks in Informatica mappings and sessions
• 4 years of experience working with Teradata EDW system using tools fastload, fastexport, Tpump, Bteq scripts
• 4+ years hands on experience with Relational and Dimensional modeling using CA-ERWIN, designed conceptual, logical and physical modelling
• Developed PL SQL packages and stored procedure
• 24/7 production support experience using Remedy and ITIL framework
• Developed and enforced ETL development standards and best practices
• Training and mentoring junior developers
• Experience in interacting with cross functional teams
• Lead Agile Scrum Meetings

TECHNICAL SKILLS:

ETL tools:: Informatica PowerCenter 10x, Informatica Power Exchange, Informatica B2B Data transformation studio, Microsoft SSIS, SSRS, Microgen Aptitude Studio, Oracle Data Integrator (ODI), EDQ Experian Pandora Data Quality tool, Address Validation tool

Database:: Oracle 12c, DB2 10.1, MS SQL Server, Teradata 15 (Fastload, Mload, Tpump, Bteq queries), MySQL, Vertica 9.x

Languages:: Java, XML, XSLT, XQuery, SQL, PL/SQL, T-SQL, python, shell scripting

Version Control and Release Management: Subversion, Git

Business Intelligence tools: Crystal Reports IX, Cognos 10, Power BI

Job Scheduler:: ESP, Control-M and Autosys

Mainframe technologies:: COBOL, JCL, VSAM, DB2, TSO/ISPF

Tools: Toad, SQL Navigator, DB Visualizer, SQL Developer, Notepad++, Ultra edit

Operating system:: Red hat, Solaris, UNIX, Windows 10

Cloud technologies: Amazon Web Service, Digital Ocean

PROFESSIONAL EXPERIENCE:

Sr ETL Developer

Confidential, Roseville CA

Responsibilities:

• Designed and Developed ETL solution for change data capture as part of clinical audit process, migrated informatica mappings from on-premise to oracle cloud environment, developed and tuned informatica mappings, executed test cases in QA environment as per business requirement
• Trained in Data Quality tool Experian Pandora 5.8, developed strategies to profile, clean and map old legacy data to the new CARS system, profiled legacy cal-access data using pandora tools to find data anomalies, developed data quality rules to clean the data, created source to target mapping to map data from old legacy system to new system, used pandora batch address verification solution to clean 20 million address records and standardize using USPS format, developed etl solution using Microsoft SSIS.
• Designed and developed ETL solution for Hyundai MDM and Enterprise Datawarehouse, developed and tuned informatica mapping, provided production support, resolved production tickets and maintenance tasks, created reports for adhoc request from Hyundai marketing team

ETL Lead

Confidential Sacramento CA

Responsibilities:

• Verizon Unified Data Model is representation of key business area for B2B, CUSTOMER, BILLING, POINT OF SALE and other DATA Products, Designed and developed ETL solution using Informatica PowerCenter to load data into UDM Data warehouse, developed PowerCenter mapping to load reference and transactional data into staging area to enrich and standardize, created two data marts each for wireline and wireless business area for revenue recognition regulatory project, developed
• ETL pipelines for revenue recognition system to support regulatory project for Verizon, modeled a data processing layer in Oracle 12c, created data pipelines to load data from Teradata EDW, Verizon billing systems,
• PeopleSoft ledger, wSAP system to OLTP and OLAP system, applied transformation to enrich and standardize the data and prepared reports for user consumption, optimized performance for mappings and tuned SQL queries, worked with data analyst to understand and facilitate the requirement, worked on ERD and dimensional modelling, developed conceptual, logical and physical data models, profiled and cleansed data using Informatica Analyst and Informatica data quality tool IDQ, managed a team of 5 ETL resource, delegating work on agile environment, conducting peer code reviews, overseeing the work of junior ETL developers

ETL Lead

Confidential - Seattle, WA

Responsibilities:

• Worked on creating an Enterprise data warehouse for Holland America Cruise linesManaged a development/testing team of 12 @ Offshore / Onsite Model, architected the ETL data flow pipelines, optimized SQL queries, trained and mentored junior ETL developers, developed, tested and tuned Informatica mappings, Administered dev/test Informatica environment, prepared reports for user consumption, worked on to create a new enterprise data warehouse for 7 cruises lines under carnival
• Created data maps using COBOL file definition to load data from mainframe system to DB2 tables, converted all the insurance policies from AXml, CXml(Client specific auto insurance policy details) to industry standard ACORD xml, heavily utilized Informatica B2B data transformation tools parsers and mapper and UDT transformation in Informatica PowerCenter to process unstructured xml data, managed a team of 10 resources in offshore/onsite environment, worked with xml, XQuery, xslt, xpath within the DB2 system, worked on Informatica Intelligent cloud service IICS to create synchronization task, data replication task between salesforce and oracle ODS data store.
• Created Informatica mapping using Informatica PowerCenter, lead a team of 8 resource in offshore/onsite environment, created etl design document, provided 24/7 production support, created reports using crystal reports for labor forecasting, assortment planning, converted old excel based reports into crystal reports, created complex Informatica mapping and tuned Informatica mapping and session for optimal performance
• Migrated COBOL program to Java Program as part of COBOL to Java migration, developed SQL queries to be integrated in java and jdbc calls, used NetBeans IDE environment, migrated large volumes of data from different platform, provided estimate for task and projects
• Developed mapping using Informatica PowerCenter, involved in unit testing, system testing of Informatica mapping, developed stored procedure in PLSQL, created and maintained technical documentation, analyze technical requirement and prepared low-level design document
• Developed COBOL jobs in Mainframe OS/390 system using COBOL, DB2, JCL, VSAM, Endeavor - Involved in system study, analysis and design and attended in-house training for Informatica 7.x
• Developed COBOL jobs in Mainframe OS/390 system using COBOL, DB2, JCL, VSAM, Pamvalet, designed low level design document and developed COBOL programs and maintained application by working on change requests