SUMMARY

• 10+ years of experience in analysis, design, development, testing, integrating and architecting solutions, migration, reporting, implementation and administration of data warehouse.
• Experience in various databases, reporting and UNIX System Software Applications.
• Established a consistent record of providing successful BI solutions and deliver benefits through the innovative use of technology Expertise in ETL framework design solutions, using Informatica, such as Source data profiling, extraction & validation, process metadata management, data exceptions, data reconciliation process, archival and disaster recovery solution.
• Expertise in architect, design, development, testing, implementation and maintenance of data warehouse solutions using ETL tool Informatica PowerCenter 6.1/7.1/8.6.1/9.0.1/9.6 and Power Exchange. Expert in developing complex mappings and debugging mappings/sessions to test and fix errors.
• Proficient in understanding business processes / requirements and translating them into technical requirements and test strategies.
• Extensive Experience working with business users, SMEs, App DBAs, ETL admins, Prod support ppl as well as senior management
• Prepared DB naming standard documents for tables, columns, indexes, views, access information, data mapping sheets with cardinalities and coordination with DBAs to get DB changes done and had created physical model.
• Wrote, tested and implemented Teradata Fast load, Multi load and Bteq scripts, DML and DDL.
• Strong in Data warehousing concepts Fact table, dimension table, star and snowflakes schema methodologies
• Proficient in Informatica Developer, Web based Analyst tool, informatica cloud, PowerCenter repository manager, Designer, workflow manager, & monitor.
• Experience in writing oracle SQL queries and PL/SQL procedures, functions and packages
• Implemented end - to-end tasks effectively throughout the project till its delivery to customer.
• Good knowledge on Informatica Data Quality Admin tasks as well.
• Strong Knowledge of Hadoop and Hive and Hive's analytical functions
• Installed and configured PowerCenter on UNIX and windows platform.
• Good knowledge on the installation and configuration of IDQ service components.
• Creation and maintenance of Informatica users and privileges.
• Excellent Client Interaction / Relationship, Leadership and Communication Skills.

TECHNICAL SKILLS

Hardware: DELL Servers, SUN E-3500/E-450 and E-250, SUN Ultra 10, SUN SPARC 10, HP-9000 K Series, Cisco UCS, Windows (32 Bit and 64 Bit)

Operating System: RHEL (ES/AS), CentOS, Solaris, HP UX, Windows

Development: PL/SQL, XML, Core Java, UNIX shell script

Tools: TOAD, Oracle SQL Developer, JDBC/ODBC, SQL*Loader, Visio

Version Control: CA Harvest SCM

Databases: Oracle 11g/10g/9i/8i/7.x, MS SQL Server, SQL Server Analysis Services, UDB DB2 9.x, Teradata V2R6/R12/R13, MS Access 7.0 SQL Server Analysis Services

Data Modeling: ERWIN

DWH Tools: Informatica 9.6.1/8.6/8.1/7.1/6.2 , Power Exchange 10.1.1 for oracle CDC, Informatica data quality, Informatica Cloud and Informatica BDM

Data Management: Oracle 9i/10G/11G, RAC

Technologies/Methodologies: OLAP, OLTP, DAC, Tidal,Tivoli, Gap Analysis, Kimball methodologies

Big Data Technologies: Cloudera Hadoop, HDFS, Hive

PROFESSIONAL EXPERIENCE

Confidential, Blue Ash, OH

Senior Informatica Developer

RESPONSIBILITIES:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Created Mass ingestion tasks to move files from GCP to Azure.
• Create mappings to convert the JSON file to relational format using the Data processor Transformation in IDQ and Unstructured Data Transformation in powercenter.
• Converted ETL mapping into Python scripts and automated the testing using Python.
• Understanding the requirements and converting them into SQL queries by using joins, union or minus queries, built in functions, Stored Procedure, Analytical functions etc.repository manager.
• Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).
• Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.
• Migrated the code into different environment and documented the migration activities.
• Creating the user and assigning the roles.
• Experience in Complex SQL Queries, Dynamic SQL, Analytical function
• Worked on the CDI mapping to push the data to Kafka.

Confidential, Los Angeles, CA

ETL Architect

Responsibilities:

• Understanding the business rules and sourcing the data from multiple source systems.
• Extracted the data from Student Database and loading into salesforce Objects using Informatica Cloud.
• Developed Cloud mappings to extract the data for different schools and load into EDA (Salesforce)
• Refreshing the mappings for any changes/additions to source attributes.
• Developed the audit activity for all the cloud mappings.
• Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
• Generated automated stats with the staging loads comparing with the present day counts to the previous day counts.
• Created Filewatcher jobs to setup the dependency between Cloud and PowerCenter jobs.
• Followed ETL standards - Audit activity, Job control tables and session validations.
• Used Exceptional mappings to generate dynamic parameter files after the staging loads.
• Used Shared folders to create reusable components (Source, target, email tasks).
• Sql queries to validate the data after loading.
• Expertise in parsing and handing structured and unstructured data like json,no-sql
• Realtime API calls to load the data into salesforce

Confidential, Herndon VA

Senior Informatica Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Involved in the entire SDLC (System Development Life Cycle) process that includes Implementation, testing, deployment and maintenance
• Created the Extraction Maps for the oracle source system using Powerexchange
• Extensively worked on Informatica Designer and workflow Manager.
• Designed and developed various reusable mappings and Mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from various sources like Oracle, Flat files and load to final EDW Oracle database
• Developed rules and mapplets that are commonly used in different mappings
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).
• Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.
• Migrated the code into different environment and documented the migration activities.
• Creating the user and assigning the roles.
• Experience in Complex SQL Queries, Dynamic SQL, Analytical function
• Worked on existing mapping for the performance tuning to reduce the total ETL process time
• Created Registration Groups, Registration maps and imported the data maps into designer.

Confidential, Auburn Hills, MI

Senior Informatica Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Involved in the entire SDLC (System Development Life Cycle) process that includes Implementation, testing, deployment and maintenance
• Developed rules and mapplets that are commonly used in different mappings
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy
• Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.
• Worked on different environments with different source and target databases like Oracle, and SQL server.
• Developed the mapping to process multiple flat file as source and staged the data into Oracle databases.
• Providing Support for IBM’s Info Sphere MDM v11.5, which operates as central repository for Dealer /Customer/ Supplier/ Employee/ Vehicle and Parts master data for the Americas.
• Experience in end to end Data quality testing and support in enterprise warehouse environment
• Worked on Installation and upgrade of the Informatica BDM from 9.6 to 10.1.1.
• Significant experience & demonstrated proficiency in all aspects of database programming on Oracle SQL/PLSQL and/or related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing
• Extensively worked on migrations and user group creation.
• Responsible for migration of the work from dev environment to testing environment.
• Responsible for solving the testing issues.
• Extensively involved in the Integration, System, and Functional Testing.

Confidential, Detroit

Application Developer

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, development teams and analysts on a scheduled basis
• Involved in the entire SDLC (System Development Life Cycle) process that includes Implementation, testing, deployment and maintenance
• Performed many multiple tasks effectively and involved in troubleshooting the issues.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner
• Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router, Update Strategy, Java
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables
• Developed mappings in Informatica to load the data from various sources into Target System to fix a Ticket Historically like fixing 5 years of data from the starting of the EDW Data warehouse.
• Worked on Design, implementation, enhancement and execution of current and new processes to achieve SLA’s via following standards.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Write Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Performed Unit testing and System Integration testing (SIT) of Informatica mappings in DEV environment and migrated code to Testing Environment (QA1 and QA2).
• Implemented the shell scripts to accomplish the typical tasks in informatica.
• Scheduled the workflows using Tivoli Job Scheduler for daily loads and monthly loads.
• Used complex procedures to do the history loads into the tables

Confidential, Kansas

Informatica Lead & Developer

Responsibilities:

• Leading the development and enhancement services for assigned product families; demonstrating broad knowledge of application and systems design; manage complex inter-system related issues; serve as an interface between team members and vendor/support teams to ensure issues are escalated, classified and documented properly.
• Tasks include owning entire data platform layer, creating end-to-end ETL architecture, design documents which contains source to target mapping, data dictionaries, ETL process details and ER diagrams.
• Involved in plan, design and analyze performance of Informatica ETL programs to address data requirements from new data sources.
• Designing, building, and maintaining new ODS and the BI Reporting Platform using Informatica 9.10 and SSRS.
• Recommended best practices for data transformations to support the data movement. Defined data migration requirements, gathering, validating and documenting data requirements.
• Translated, merged, cleaned up and/or mapped data into conceptual, logical and physical data models.
• Involved in activities related to data cleansing, data quality and data consolidation using industry standards and processes.
• Identified, developed, and documented data standardization, data enrichment operations, data validations, data security requirements, and data exception handling processes.
• Involved in Reviewing ETL programs developed for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL process, programs and scripts
• Conducting root cause analysis, resolving performance, production problems and data issues.
• Performance tuning of database and SQL queries to match sub-second SLA
• Providing ongoing maintenance and support of assigned ETL applications.
• Establishing and enforces data warehousing standards at the client site to meet client requirements and business needs.

Confidential

Project Lead

Responsibilities:

• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
• Worked exclusively on performing the ETL to Level 1 as is staging, Level 2 staging, DW load based on the business rules and transformation specifications.
• Extensively used Transformation Language functions in the mappings to produce the desired results.
• Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Analyzed requirements from the users and created, reviewed the specifications for the ETL.
• Designed Incremental strategy, Created Reusable Transformations, Mapplets, Mappings/Sessions/Workflows etc.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).
• Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.
• Migrated the code into different environment and documented the migration activities.
• Creating the user and assigning the roles.
• Worked on existing mapping for the performance tuning to reduce the total ETL process time

Confidential

Informatica Lead & Developer

Responsibilities:

• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Teradata, Xml, csv
• Delimited files transformed based on business requirements and loaded to Data Warehouse
• Developed several mappings in Informatica to load SCD Type 2, SCD Type 1,Scd Type 0 Dimensions
• Developed complex mappings to load SCD Type 2 Dimension tables with Dynamic Cache.
• Implemented User defined functions
• Implemented Push Down Optimization to improve the performance
• Implemented Query Banding to improve resource utilization at Teradata level
• Developed and loaded the fact tables.
• Developed Bteq Scripts
• Developed the shell scripts for FTP the source files
• Coordinated with Client at the Requirement phase and developed the LLD for the ETL mappings
• Migrated the informatica code from one environment to another Environments
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions
• Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizer transformations.
• Creation and maintenance of Informatica users and privileges.
• Worked with Adhoc request and provided necessary data using the Teradata-SQL
• Migration activities have done to different environment using the deployment groups and import /export of the xml files

Confidential

Technical Lead

Responsibilities:

• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Teradata, Xml, csv
• Delimited files transformed based on business requirements and loaded to Data Warehouse
• Installation & configuration of Informatica PowerCenter (Client, Repository Service & Integration Service) on UNIX machine
• Developed several mappings in Informatica to load SCD Type 2, SCD Type 1,Scd Type 0 Dimensions
• Developed complex mappings to load SCD Type 2 Dimension tables with Dynamic Cache.
• Implemented User defined functions
• Implemented Push Down Optimization to improve the performance
• Implemented Query Banding to improve resource utilization at Teradata level
• Developed and loaded the fact tables.
• Developed Bteq Scripts

Confidential

Senior Software Engineer

Responsibilities:

• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Oracle, Xml, csv
• Delimited files transformed based on business requirements and loaded to Data Warehouse.
• Configured the SOA Calls using web services.
• Created the Data Replication, Data synchronization tasks and defend Task Flows
• Scheduled the Task flows at informatica cloud level to extract the data from SFDC application
• SOA Call are done using the Informatica Web consumer Transformation for Address Doctor and D&B Real-time LKP Call
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Participate in deployment, system testing, UAT.
• Engage in peer reviews during design, coding and testing
• Ensure adherence to quality processes
• Provide leadership and guidance to project team to ensure that all aspects of ETL design and implementation align with The Company's reference model.
• Set strategy and oversee design and development of EDW staging areas and target tables.
• Establish and ensure appropriate data quality and ETL metrics are defined, monitored and managed.
• Address and resolve technical design issues as they are appropriately escalated.
• Prepare implementation plans when moving a code to production.
• Perform system testing and monitoring
• Contribute to process improvement initiatives (best practices, six sigma etc)
• Optimize ETL design and tools to gain efficiency and functionality.
• Work with support team to define methods for and potentially implement solutions for performance measuring and monitoring of all data movement technologies.
• Develop strategy for implementing data profiling, data quality, data cleansing and ETL metadata.
• Develop strategy and lead implementation for deployment of data integration into EDW.