SUMMARY:

• 14 Years of IT experience in the Requirement Gathering/Analysis, Data Analysis, Application Design, Application Development, Implementations and Testing of Applications in Datawarehouse, and Client/Server Projects.
• 12+ years of strong data warehousing experience using Informatica PowerCenter 9.x/8.x/7.x/6.x/5.1/1.7 as ETL tool, Informatica Data Quality (IDQ) using Informatica Analyst and Developer tools.
• Hands - on experience with Informatica Big Data,Hadoop,Hive Systems and good knowledge on Vertica systems
• Hands on experience using Push down optimization.
• Hands on experience on different databases Teradata,Oracle,SQL Server,Netezza, Postgres, SalesForce, DB2, Hive systems
• Hands on experience with Teradata load utilities Tpump, FastLoad, MultiLoad, Fastload
• Expertize Data Quality experience in Data Profiling, Cleansing and Standardizing the Data using Informatica Data Quality (IDQ) tools like Informatica Analyst and Developer.
• Agile /scrum excellence
• Good exposure in Facets Trizetto healthcare system
• Good knowledge and hands on experience in hpXr healthcare system
• Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Hands on experience on Dimensional Data modeling and Relational Data modeling.
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with Administrator functions of Repository Manager.
• Extensive experience in Data Warehouse, Data Mart and Business Intelligence using OLAP/DSS tools
• Implemented the RALPH KIMBELL design strategies on metadata
• Involved in developing Data modeling, Logical/Physical model & ER-Diagrams using ERWIN
• Involved in complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Hands on experience on Integrating Informatica with Salesforce data
• Hands on experience on using Informatica Webservices.
• Good knowledge and experience in Postgres DB and Salesforce data.
• Worked with Onsite and Offshore model and lead the team
• Extensive experience in data analysis to improve overall efficiency to support decision making
• Effective problem-solver. Organized.
• 5 years of Tech Lead and Architect experience.

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i/8i/7.x, SQL Sever 2012, Teradata, DB2,Postgres,SalesForce,Netezza

OS: UNIX, Confidential Mainframes, Windows 200/NT/Xp/98/95, Sun Solaris, DOS

ETL Tools: Informatica PowerCenter /PowerMart 8.x/7.X/ 6.1.0/5.1.0/4.7.2/4.6 , PowerConnect,IDQ,Hadoop,Hive

PROFESSIONAL EXPERIENCE:

Confidential

Sr.ETL Designer

Responsibilities:

• Worked on Data Masking and Data Encryption for various scenarios, Oracle DB and SQL server, Informatica, java approach to apply encryption on sensitive fields.
• Worked on analysis and various work around options for LSF to AUTOSYS migration techniques.
• Worked on Analysis and ETL Design for Jabbari project, responsible for creating technical spec.
• Created DB partitions for SQL Server Final Jabbari application table
• Developed mappings to fetch data from Source, load to Staging (Oracle) and Confidential (SQL Server) layers.
• Converting portfolio Oracle DB procedures to Informatica processes
• Worked on Jabbari Performance Tuning to process huge volume of data.
• Worked on using different transformations like Source Qualifier, Expression, Joiner,Lookup, Aggregator, SQL Transformation, Filter and Router transformations.
• Co-coordinating with middleware team for deploying the Jobs.
• Developed Unix scripts to plugin ETL jobs.
• Worked on Autosys Jils for LSF to Autosys Migration objects.
• Worked on coding for sql server and Oracle DB procedures, java approach for Encryption /masking solution for Account num/sensitive fields.

Environment: Sql Server 2016, Informatica 9.6.x, TERADATA 15.0,TFS (code checkin),Oracle,Unix

Confidential

Sr.ETL Designer/Informatica Lead/Sr. Data Analyst

Responsibilities:

• Worked on Analysis and ETL Design document to convert business rules to ETL specification document.
• Developed mappings to fetch data from WCDIR, load to Staging and Confidential layer (SQL Server) using different transformations like Source Qualifier, Expression, Lookup, Aggregator, SQL Transformation, Normalizer, Filter and Router, Web service transformation.
• Co-coordinating with middleware team for deploying the Jobs.
• Developed Unix scripts to plugin ETL jobs.
• Worked on Autosys Jils and scheduling jobs.
• Co-coordinating with ETL Offshore team and responsible for code review.
• Worked on sql server procedures and audit scripts

Environment: Sql Server 2012, SQL Developer, SQL, PL/SQL, Unix Shell scripting, Autosys, JIL Scripts, TERADATA 15.0, Informatica 9.6.1

Confidential, New York

Sr.ETL Designer/Sr. Informatica Lead Developer

Responsibilities:

• Worked on Analysis and coming up with naming standards for Stage and Confidential tables.
• Converting human input R script logic to ETL
• Involving in business discussions to convert data in 3NF combining multiple subject areas.
• Developed mappings to fetch data from Phoenix, load to Staging and Confidential layer (Teradata network sales) using different transformations like Source Qualifier, Expression, Lookup, Aggregator, SQL Transformation, Normalizer, Filter and Router, update strategy transformation
• Worked on dynamic parameter mapping creation to extract data based on control date
• For optimal performance used TPT connection for huge volume of data
• Worked on data movement from flat files to Teradata Confidential using Teradata Fast Load
• Worked on push down optimization to improve performance for informatica mappings

Environment: Sql Server 2012, Informatica 9.6.1, TERADATA 15.0

Confidential, San Ramon, CA

Sr.ETL Designer/Lead Developer

Responsibilities:

• Deposits data is sourced from FHB and BOW core systems (IM, ST, etc.) into EDW via FDM.
• BOW and FHB daily deposit data is consolidated and enriched with counterparty and product classifications in the EDW FARM.
• Data comparison and analysis between FDM and EDR systems for backfill.
• Worked on IM/ST backfill proj design and coding.
• Gap analysis or Data analysis between FDM and EDR.
• Come up with ETL Design for Deposits GL Adjustments.
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations, Union Transformations etc.
• Created re-usable transformations and Worklets
• Created re-usable transformations and Worklets
• Additional data is used to enhance and enrich the deposit data, primarily adding counterparty and product classifications.
• Worked on PL/SQL procedures for publishing data
• Audit of ETL process to insure completeness of data movements and transformations using DQ Framework.
• Developed Unix scripts for health checks or audit data between source and Confidential

Environment: Informatica 9.6.1 Oracle 11g, TOAD, SQL, PL/SQL, Unix Shell scripting

Confidential, Mountain View, CA

Data Ingestion Engineer/ ETL engineer

Responsibilities:

• Automate the import of data from a variety of sources into a singular data source coordinated with ETL engineers for ingestion of various data sources
• Designed, developed and tested application
• Suggested effective enhancements for existing automation framework.
• Participated in investigation and testing of complex problems.
• Working with Operations and QA team to bring into client main data platform new datasets from various internal product groups.
• Provided technical guidance during work sessions and design reviews.

Environment: Informatica 9.6.1, Hadoop,Hive,Netezza, Oracle 11g, SQL Server,GIT (SCM),STASH

Confidential, Palo alto, CA

ETL Consultant/ETL Lead/IDQ Consultant

Responsibilities:

• Involved in data analysis, applying data quality checks and profiling using IDQ tools Developer and analyst
• Developed Mapping Specifications using Informatica Data Quality Analyst and Developer tools.
• Created and applied rules based on the edit checks to validate the data.
• Developed mappings to standardize contact data using Address Validator transformation.
• Created Mapplets to reuse the edit check logic across multiple mappings.
• Extensively used Data Quality Transformations like Standardizer, Match, Merge and Parser etc.
• Performed Join analysis using Informatica Developer to identify the orphan records.
• Created High level design documents, hand it over to Confidential IST Team for development
• Worked on design and development of Informatica complex mappings or interfaces
• Worked on Configuration side EBS/PDH Integration with Informatica
• Integration testing Inormatica with Oracle EBS Application
• Worked on Unix shell scripting for alert notification upon if integration service check failure and
• Prod to Non Prod data movement.
• Worked on Prod to Non Production data movement design and coding.
• Responsible for ETL Code review and design suggestion changes
• Analyzing the data for defects and fixing the defects.
• Co-ordination or support with QA team for issue resolution.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, SFDB,Oracle, Flat files).
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Implemented sending of Post-Session Email once data is loaded.
• Worked on Sales Force DB system as Source and Confidential .

Environment: Informatica Power Center 9.x, Workflow Designer, Power center Designer, Repository Manager, Oracle 11g, Linux, SQL Server,Oracle EBS/E-Business Suite,SFDC, Informatica Web Services.

Confidential, SanFrancisco, CA

ETL Designer/ETL Engineer/Infrastructure Engineer/SME/IDQ Consultant

Responsibilities:

• Used Informatica analyst to profile data.
• Created profiles to identify the patterns of the data and analyze the data quality.
• Performed Join analysis using Informatica Developer to identify the orphan records.
• Created rules and applied to the profile to measure data quality progress.
• Created score cards using Analyst tool.
• Create and update reference data in analyst tool.
• Developed mappings to standardize contact data using Address Validator transformation.
• Extensively used or worked on using IDQ developer client for data profiling and identifying duplicate records,parsing string or divide string using delimiter or regular expression.
• Created Data quality mappings using parser,joiner, match transformations etc
• Worked on identifying duplicated data using match transformation by using biagram algorithm technique, and based on the business input load or filter data
• Converting business rules to ETL specs for all the systems
• Created High level design documents, hand it over to WFIS team for Development
• Worked on design and development of Informatics mappings, workflows to load data into staging area and data mart.
• Responsible for ETL Code review and design suggestion changes
• Analyzing the data for defects and fixing the defects.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Tuned performance of mapping and sessions by optimizing source, Confidential bottlenecks.
• Infrastructure support and Configuring NDM
• JIL creation overall flow,automation for all systems for LARS project
• Implemented Audit and Reject process for STAGE load
• Created re-usable transformations and mapplets
• Worked with pmcmd commands and configuration
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.

Environment: Informatica Power Center 9.x, Workflow Designer, Power center Designer, Repository Manager, Oracle 11g, Linux, SQL Server,Autosys,IDQ 8.6

Confidential, San Jose, CA

ETL Designer/ETL Engineer

Responsibilities:

• Come up with Confidential Scripts to create Postgres,Salesforce objects in Oracle DB
• POC for Liferay,Canvas and Salesforce ETL move
• Come up with High level and Low level Design document
• Design Informatica Interfaces
• Primarily responsible for ETL design, coding and testing strategy
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations,Union Transformations etc
• Created re-usable transformations and Worklets
• Involved in data analysis
• Worked on Postgres,Salesforce connection issues
• Worked on extracting Salesforce data to Stage on incremental basis.

Environment: Informatica Power Center 9.x, Workflow Designer, Power center Designer, Repository Manager, Oracle 10g, Windows Scripting, Windows NT/2000/XP,Postgres,Salesforce,Liferay,Canvas

Confidential, Newport Beach, CA

ETL Designer

Responsibilities:

• Converting business rules into ETL technical specifications
• Design Informatica Interfaces
• Primarily responsible for Code Reviews
• Design suggestion changes for DI HUB processes
• Coming up with Design plan and Preparing the ETL Design document
• Creating Unit test cases and plan for Unit testing approach
• Analyzing the data for defects and fixing the defects
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations,Union Transformations etc
• Designed mapplets using Mapplet Designer and used those Mapplets for reusable business logic
• Implemented Error Handling Strategy
• Created re-usable transformations and Worklets

Environment: Informatica Power Center 9.x, Workflow Designer, Power center Designer, Repository Manager, Microsoft SQL server Management Studio 8.0,SSIS,SSRS, Windows Scripting, Windows NT/2000/XP.

Confidential, SanFrancisco, CA

ETL Architect/ ETL Designer Lead

Responsibilities:

• Involved in Requirements review sessions and working with data modeler for design changes
• Converting business rules into ETL technical specifications
• Design Informatica Interfaces
• Proving the requirements to team and clarifying the requirements and managing the team
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Involved in evaluating data models and physical databases for variances and discrepancies.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Primarily responsible for Design and Code Reviews.
• Performance tuning and design suggestion changes for existing hpXr processes
• Coming up with Design plan and Preparing the ETL Design document
• Analyzing the data for defects and fixing the defects
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations,Union Transformations etc
• Designed mapplets using Mapplet Designer and used those Mapplets for reusable business logic
• Implemented Error Handling Strategy
• Created re-usable transformations and Worklets
• Wrote shell scripts to perform pre-session and post-session operations
• Co-ordinating with middleware team for migrating Informatica objects into test environment
• Impact analysis for hpXr upgrade and testing
• Automating the ETL applications using Tidal tool
• Co-coordinating/Managing ETL Offshore team

Environment: Informatica Power Center 8.x, WorkFlow Designer, Powercenter Designer, Repository Manager, Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Windows NT/2000/XP, Visio, Business Objects,PVCS, TIDAL Enterprise scheduler, Informatica Data Quality(IDQ), Informatica Data Explorer (IDE),Toad, SQL Developer,Erwin

Confidential, Waukegan, IL

ETL Architect /SME

Responsibilities:

• Created High Level and Low level design documentation for National,Sub National, Comm Dashboard and RSA Systems
• Conducted code review sessions with BSA, Project Managers and with Technical Team.
• Used SQL * Loader to load the data from Flat files to Oracle for Comm Dashboard system.
• Created number of PL/SQL procedures for may other updates.
• Developed complex aggregate, join, look up, filter, router transformation logic to generate consolidated data needed.
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations
• Designed and optimized moderate to complex Initial load to populate SCD Type-2 using date format.
• Improved the session performance by pipeline partitioning.
• Upgraded Powercenter 7.x to 8.x.
• Generated Unit and integration Test Plans and related documents
• Created Workflows in the Workflow designer and executed tasks such as Sessions, Commands, etc. And Monitored transformation processes using Workflow monitor
• Involved in performance tuning of the Informatica mapping and identifying the bottlenecks.
• Wrote JIL scripts to automate the data load into datawarehouse
• Led the team in the absence of the project leader.

Environment: Informatica Power Center 7.x/8.x, WorkFlow Designer, Powercenter Designer, Repository Manager, Oracle 9i, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Windows NT/2000/XP, Visio, Kalido DIW,Business Objects,Erwin

Confidential, San Jose, CA

Sr.Informatica Developer / Data modeler

Responsibilities:

• Involved in Analysis and detailed level of Mavent mapping documentation
• Interacted with the end users, Project Manager and other resources in understanding the requirements.
• Primarily responsible to convert business requirements into system design
• Designed logical and physical database designing using ERWIN Tool.
• Scheduled the ETL jobs daily. Weekly and monthly based on the business requirement
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations
• Worked extensively on Flat Files, as the data from various Legacy Systems is flat files.
• Involved in Error Handling Strategy.
• Implemented slowly changing dimensions (Type 2) methodology to keep track of historical data
• Created unique primary key values to replace missing primary keys using Sequence Generator Transformation making reusable to use the same Sequence Generator in multiple mappings
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Created Workflows in the Workflow designer and executed tasks such as Sessions, Commands, etc. And Monitored transformation processes using Workflow monitor
• Created various tasks like Assignment, E-mail and Decision etc
• Wrote shell scripts to perform pre-session and post-session operations

Environment: Informatica Power Center 6.x/7.x, WorkFlow Designer, Powercenter Designer, Repository Manager, XML, Oracle 9i, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Windows NT/2000/XP, Visio, Erwin 3.5.2,BugZilla