PROFESSIONAL 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.
• ETL Development - 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.
• Very strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• 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 Data Quality validation, Data Profiling and Data analysis in Enterprise Data Warehouse environment.
• Implemented the Data Quality solution with the appropriate DQ Rules, Metrics and projects.
• Experience in writing oracle SQL queries and PL/SQL procedures, functions and packages
• Implemented the Parser, Mapper, XMap to load the huge XML and Json files on Informatica B2B Data Transformation.
• Extensively worked on Informatica Data Quality and Informatica Power center throughout complete Data Quality and MDM projects.
• Implemented end-to-end tasks effectively throughout the project till its delivery to customer.
• Very good proficiency in Informatica Data Quality 9.5.1/9.6.1 and Informatica power center 9.x/8.x/7.x
• Extensively worked on Informatica Analyst tool 9.5.1/9.6.1 as initial phase.
• Good knowledge on Informatica Data Quality Admin tasks as well.
• Very strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Good skills in analyzing trend charts from score cards to analyze the threshold which is to be considered in further development
• Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
• Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
• 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:

DELL Servers, SUN E3500/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 Data Analyzer, Informatica Master Data management, Informatica Cloud, Informatica Data Transformation(B2B) and Informatica BDM Business Objects and OBIEE and tableau

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

Academic Profile: Bachelor of Technology in Computer Science from Nagarjuna University.

PROFESSIONAL EXPERIENCE:

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
• 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 DB2, Oracle, Flat files, SQL server 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.
• Worked on multiple projects using Informatica developer tool IDQ of latest versions 9.5.0 and 10.1.1.
• Involved in migration of the mapps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ.
• 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 Teradata, Oracle, and SQL server.
• Developed the mapping to process multiple flat file as source and staged the data into teradata and 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 powercenter,IDQ and BDM from 9.6 to 10.1.1.
• Working on Cloudera Hadoop CDH 5 admin tasks.
• 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
• Applied various types filters like Data source filters, Quick filters and Context Filters in Tableau.
• Created table calculations, calculated fields and parameters in Tableau.
• Responsible for solving the testing issues.
• Extensively involved in the Integration, System, and Functional Testing.

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 DB2, Oracle, Flat files, SQL server 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.
• 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
• 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, 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
• 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 DB2, Oracle, Flat files, SQL server and load to final EDW Oracle database.
• Extensively worked on Informatica IDE/IDQ.
• Used IDQ to complete initial data profiling and removing duplicate data.
• And extensively worked on IDQ admin tasks and worked as both IDQ Admin and IDQ developer.
• Performed many multiple tasks effectively and involved in troubleshooting the issues.
• Implemented Data replicating and data synchronization tasks in informatica cloud for SFDC.
• 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, XML Parser, Java, Unstructured Data Transformation, Web Consumer transformation.
• Creating and editing the xml views and Pivoting the elements in the XML editor
• Loaded the huge xml files into database using xmap and mapper in informatica developer tool.
• Json files are loaded into the databases using the Parser in informatica data transformation (B2B) tool.
• Worked on creating the profiles and scoreboard in informatica Data Explorer to analyze the huge data.
• Implemented Address Validate, Case Converter, Data Processor, Merge, Match, Comparison, Consolidation, Standardizer, Weighted Average, Data Masking.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
• 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.
• Mentored and monitored Information Management DQ team with Business, Technical and Processes information.
• 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.
• Created Complex DQ Mappings to maintain data quality using transformations like Used source based, Target based and full Pushdown optimization techniques and Key range, Hash function, Round Robin pipeline partitioning for better performance.
• 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.
• Creation of Informatica Power Exchange datamaps and import them into Power Center.
• Imported the SFDC objects using the power exchange.
• Designed Hive tables to load data to and from external files.
• Created mappings to load the data into Hive tables in informatica Developer.
• 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
• Used IDQ to complete initial data profiling and removing duplicate data
• Implemented Address Validate, Case Converter, Data Processor, Merge, Match, Comparison,
• Consolidation, Standardizer, Weighted Average, Data Masking.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment.
• 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.
• Used IDQ to complete initial data profiling and removing duplicate data
• Implemented Address Validate, Case Converter, Data Processor, Merge, Match, Comparison,
• Consolidation, Standardizer, Weighted Average, Data Masking.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment.
• 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.
• 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 and Update Strategy
• 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

Project 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
• 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
• Used IDQ to complete initial data profiling and removing duplicate data
• Implemented Address Validate, Case Converter, Data Processor, Merge, Match, Comparison,
• Consolidation, Standardizer, Weighted Average, Data Masking.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment.

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 Power Center (Client, Repository Service & Integration Service) on UNIX machine
• Utilized of Informatica IDQ 9.5.1 to complete initial data profiling and matching/removing duplicate data.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 9.5.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 9.5.1 for data quality measurement.
• Worked on data quality transformation like parser, standardizer, match and so on
• 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
• Used IDQ to complete initial data profiling and removing duplicate data
• Implemented Address Validate, Case Converter, Data Processor, Merge, Match, Comparison, Consolidation, Standardizer, Weighted Average, Data Masking.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment.
• 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
• Tuning the Informatica complex scd type 2 and fact mapping
• Handled the 3 member team including the onsite and client communications.
• Installed and configured Power Center on UNIX platform

Confidential, San jose

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.
• 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.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters,
• Lead definition, execution, and communication of ETL strategy, design and processes to support the EDW environment
• 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.
• Created Unix scripts to Check the different Scenarios Regarding the XML Created the FTP Scripts to put the files in different servers and to get the files from different FTP Servers
• Created the OBIEE RPD
• Created the Dashboards using the prompt
• Created the different types of report.
• 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
• Created the Execution plans at Dac level to informatica workflows
• Created Tasks at Dac level.
• Created the Subject Areas at Dac level
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and d Mapping Designer.
• 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.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters,
• Lead definition, execution, and communication of ETL strategy, design and processes to support the EDW environment
• Perform technical reviews of code and test plans created by team member
• 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)
• Regularly interact with Business Intelligence leadership on project work status, priority setting and resource allocations.
• 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. Couple of Unix scripts to Check the different Scenarios Regarding the XML files
• Created the FTP Scripts to put the files in different servers and to get the files
• Created the OBIEE RPD
• Created the different types of report.