SUMMARY:

• 11 years of Technical & Functional expertise in DW&BI using Informatica 5x, 7x, 8x, 9x, 10x Power Center, Power Exchange, Developer (DQ, BDM), Analyst, IDL, Cloud, Data Studio, Oracle, Teradata, SQL Server and UNIX Shell Scripting.
• Experience in working on Big data technologies such as Apache Hadoop, HDFS, Hive and SQOOP
• Led ETL Projects and development resources from inception to completion of the projects
• Experience in working with Map Reduce programs, HDFS commands and Hive commands
• Experience working on Batch data ingestion into Hadoop Eco System using SQOOP from RDBMS Oracle & Teradata.
• Familiar with Bottom up approach and Top down approach.
• Expert in ETL Data Architecture, in addition hands on experience in Logical & Physical data modeling using ERWIN.
• Expert in designing Data warehouses/Data Marts/Data store as per business requirements.
• Expert in Informatica Power Centre and Developer design principles of building ETL Design, Development, Testing and Migration.
• Hands on profiling, rules and reference table concepts using Informatica Analyst of IDQ
• Hands on Labeling, Standardization, validating address using Address doctor by Informatica Developer of IDQ
• Worked on Confidential Data maps using Power Exchange Navigator to read Oracle sources
• Expert in data integration for Oracle, SQL server, DB2, Salesforce.com (SFDC), COBOL, XML, Flat files, WSDL and JSON
• Applied Performance Techniques to optimize SQL and Informatica ( sources, targets, mapping and sessions bottlenecks)
• Worked extensively in building Dimensions, Facts, and Star Schemas and Snow Flake Schemas
• Comprehensive experience of working with Type1, Type2 and Type 3 methodologies for Slowly Changing Dimensions
• Expert in Informatica b2b data transformation studio component like Parser, Serializer, Mapper, Transformer and Streamer.
• Used Nested components like formats, document processers and anchors.
• Explored Informatica TDM for data masking, minimizing risk of data breach by eliminating exposure of sensitive data.
• Worked on test data generation to check the code feasibility while handling huge volume of data.
• Strong experience using SQL & PL/SQL objects such as Tables, Views, Functions, Stored Procedures, Sequence and Triggers.
• Hands on experience in Teradata BTEQ scripts, FASTLOAD, TPUMP, MULTI LOAD, FASTEXPORT Loaders
• Hands on experience in UNIX commands, scripting and PMCMD, INFACMD command
• Gained extensive knowledge in Banking & Finance, Insurance, Telecom and Healthcare Domains
• Experienced in assessing ETL sizing for multiple projects/applications and resource utilization.
• Member of Center of Excellence team, provide support to DWH practice for any technical challenges and POC
• Proficient in documentation like HLD, LLD, Application Understanding document and Interface Agreements
• Strong ability in software testing W.R.T writing test scripts /cases, preparing test data, execution of Unit Testing, SIT and UAT
• Being a Project Lead, adroit in providing effective resolution to customer queries and forecasting roadblocks
• Excellent communication and interpersonal skills, quick adaptability, learning capability, programming skills, exceptional user facing skills and ability to meet tight deadlines
• Utilized in - depth knowledge of functional and technical expertise in Data Warehousing and other leading products and technologies in conjunction with industry driven solutions to the Customer

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Exchange, Developer (IDQ, BDM), Analyst, IDL, Cloud and Data Studio

Big Data: Apache Hadoop, HDFS, Map Reduce, Hive and SQOOP

Data Bases: Oracle, SQL Server, DB2, Teradata, Sybase and SFDC

File Systems: XML, Flat Files, JSON, WSDL, COBAL and Excel

Reporting Tools: Business Objects

Schedulers: Control-M

Modeling: Erwin

OS: UNIX, RedHat Linux 5.8, LINUX, Solaris, Windows 10/7

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix.

ETL Lead/Informatica Analyst

• Involved in gathering requirement and preparing Interface Agreement, UNIT specs, Dataflow Design, Mapping Specification, Test Scenarios, Migration Change Packet, TIR and TIP for development and testing phases.

• Responsible for End-to-End deliverables and estimations of Data Modeling, Design, Development, Testing and Deployment
• Responsible for Design, Data Modeling, Transformation, Normalization and BI Architecture by Performing data research, analysis, conceptual and logical data modeling to validate and document business data artifact with an in-depth understanding of entity relationship design, data normalization & relational modeling techniques
• Identify key business processes and deliver subject specific OLAP data-marts.
• Work very closely with business analysts, development teams and project managers for requirements and business rules.
• Support ongoing data modeling efforts for Development, QA, Production environments
• Experience with ERWIN or similar data modeling tools
• Experience deploying and supporting large, complex data warehouse/business intelligence solutions.
• Built data lakes (landing zone, transformed zone and operational zone) and loaded data into Amazon Red shift directly from Amazon S3 using BDM.
• Leveraged Informatica BDM to load data from Oracle to HDFS and vice versa
• Led development, implementation and take the responsibilities for setting up Informatica BDM tool & Hadoop cluster environment from inception to production
• Closely worked with Business users, Informatica Product support group and Hortonworks teams
• Worked on pushing existing ETL logic to Hadoop cluster using Informatica BDM tool
• Hands on with data prep worksheets in IDL and SQL to Mapping using BDM tool
• Done cleanse, parse, standardization, validation, scorecard, exception, notification and Extensively Worked on Informatica Objects like profiling, Labeling, Standardization, Parser, Keygen, match, decision, Consolidation, Decision, Address Validator/Address Doctor, XML source and Target, Stored Procedure, Lookup, Normalizer, Java, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator Transformation using Developer Tool and Power Center Tool.
• Extensively worked on IDQ rules, reference table and Mapplets.
• Extensively used IDQ for functional analysis, Profiling and for development activities and also invoking IDQ as Mapplets.
• Extensively followed best practices and handled complex scenarios
• Estimation and planning for ETL Design/Development
• Extensively worked on reusable Transformations, User defined Functions, Mapplets and Mapping Parameters, Mapping Variables, Workflow Variables, reusable Sessions and Worklets
• Analyzed transformation inputs and outputs requirements using Informatica B2B Data Transformation.
• Created and configured Data Transformation project and deployed as a service that runs in Data Transformation Engine using Informatica B2B Data Transformation.
• Involved in Projects Running, Testing and Deployment activities for B2B Data Transformation
• Involved in TDM activities like user defined profiling, Plan and creation of workflow and execution.
• Extensively worked on complex mappings and bottlenecks in order to improve performance and error free code
• Created Pre and Post Session scripts for checking file validations/existence/count/archival/versioning
• Migrated all the Interfaces from the DRS to QP and CRMFSM to CERPS
• Involved in Dev to QA and Prod Deployment activities across the platforms
• Provided excellent customer service to the internal functional team by proactively following up with the issues in hand
• Extensively worked on XML Sources and Targets

Confidential

ETL Lead/Sr. Developer

Responsibilities:

• Involved in gathering requirements & preparing Functional, Technical (HLD, LLD, UNIT specs), Test Cases and Interface Agreements.

• Responsible for End to End deliverables like Design, Data Modeling, Development, Testing and deployment
• Led development teams to deliver projects and Worked with upper management on the strategy on implementing solutions
• Used Informatica Big Data Edition and developed ETL code for Hive mode
• Involved in Logical and physical modeling for ODS & DWH environments.
• Involved in data profiling and generating scoreboard, IDQ mappings and Deployment IDQ code into Power Center
• Data ingestion from various application data into Cloudera Hadoop Hive (data warehousing package/infrastructure built on top of Hadoop)
• Extensively Worked on Informatica Objects like profiling, Labeling, Standardization, Parser, Key generating, match, decision, Consolidation, Address Validator.
• Responsible for Normalization, Partitions, Aggregation, data conversion solutions
• Involved in identifying the technology scope, execution method for the MBODS application
• Extensively worked on Informatica objects, reusable Transformations, User defined Functions, Mapplets, Mapping Parameters, & Variables, reusable Sessions, Workflow Variable and Worklet
• Transformation usage - B2B, Data masking, HTTP, Stored Procedure, Lookup, SQL, VSAM Normalizer, Java, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator and XML Transformations in the mappings
• Created project with in JSON Schema using B2B data transformation also worked on Failure Handling, Validation
• Involved in Projects Running, Testing and Deployment activities for B2B Data Transformation
• Involved in I Confidential emental loads after applying complex logics to meet business solutions
• Responsible for data masking and test data generation to protect sensitive data of Dev environment using Informatica TDM
• Hands on experience in profiling (using defined policies, data domains and rules), Plan, workflow generation and execution.
• Worked on Teradata loaders and standard definitions for COBOL copybooks
• Explored Informatica Power Exchange to read data from mainframes by enabling it to parse VSAM formats, IMS integrated WebSphere MQ with Informatica Power Center by creating MQ SQ and associated SQ.
• Implemented Power Exchange Confidential for Oracle by Creating Power Exchange Capture Registrations and Extraction Maps
• Performed a Database Row Test on an Extraction Map
• Configure Power Center to Process Power Exchange Change Data by Importing Extraction Maps for Source Tables
• Extensively worked on ETL/SQL optimization techniques to address performance/load issues
• Worked on Pre and Post Session Scripts to perform file validations/existence/count/archival
• Involved in executing/maintaining daily/weekly/monthly ETL jobs and Fix issues if any
• Provided excellent customer service to the internal functional team by proactively following up with the issues in hand
• Identified the problem areas where cost can be reduced by minimizing manual efforts using ETL Code Generator

Confidential

Sr. ETL Developer/Lead

Responsibilities:

• Responsible for Requirements gathering, Design ( BI Architecture), Data Modeling, Data loading strategy ( Normalization, Partitions, Aggregations), Data conversion, Data Integrations, Security and Performance evaluation, Estimations, Integrating SFDC Applications into EIW, Code review and impacts

• Extensively worked on Informatica objects, Reusable Transformations, User Defined Functions, Mapplets, Mapping Parameters & Variables, Reusable Sessions, Workflow Variable and Worklet
• Worked on full and i Confidential emental loads and validation projects for large data warehouses along with impact analysis in DWH
• Transformations usage like Lookup, SQL, Normalizer, Transaction Control, Java, Joiner, Aggregator, Expression, Router, Update Strategy, Sequence Generator in the Mappings
• Hand on profiling, Cleansing, Standardization, scoreboard using IDQ using various transformations.
• Imported SFDC objects into Informatica
• Worked on SFDC source, Targets, Merge, Lookup Transformations
• Involved in I Confidential emental loads after applying complex logics to meet business solutions
• Worked on Code atomization using ETL Code accelerator
• Extensively worked in troubleshooting areas for resolving errors, addressing performance issues in ETL/SQL
• Responsible for data masking and test data generation to protect sensitive data of Dev environment using Informatica TDM
• Prepared Test Strategy, Test Plan, Test Scripts and Risk Assessment Documents
• Prepared and did walkthrough of functional requirements document and detailed design documents
• Involved in Production Support

Confidential, Chicago

Sr. ETL Developer

Responsibilities:

• Involved in gathering Functional/Technical requirements from Client during transition tenure and getting signoff for applications

• Involved in Production support for ProMIS and ESTER
• Involved in change requests and incidents solutions for ETL module
• Involved in ad-hoc reporting, self-service data visualization, dashboards and predictive analytics
• Involved in building Universe and Dash Board for Reporting analysis
• Daily checkouts and manual runs across all the regions like Dev, QA, DR
• Generated XML files for reporting services
• Working on fast-paced and constantly changing environments with an ability to work under pressure and tight deadlines involving multi-tasking and prioritizing activates

Confidential

ETL Developer

Responsibilities:

• Integrated data into warehouse from various systems like flat files and oracle

• Generated parameter files for all the staging mappings using Informatica
• Developed mappings to load data into Slowly Changing Dimensions and Fact tables
• Scheduled workflows using Control-M tool
• Developed and implemented data verification and testing methods into data warehouse to achieve data quality
• Involved in tuning mappings and sessions to gain performance
• Performed Unit test case design, Unit Testing and Reconciliation for DEV and SIT
• Gained practical knowledge in Data Modeling using ER-win tool

Confidential

ETL Developer

Responsibilities:

• Prepared Informatica technical specifications for application development

• Extensively worked on Informatica Designer and workflow manager and involved in code reviews
• Worked on sources like flat files, oracle
• I Confidential eased productivity for reporting by developing facts
• Created Reusable Objects, Mapplets and Worklet, also used most of the task types from workflow manager

Confidential

ETL Developer/Support

Responsibilities:

• Involved in EDW mappings, sessions and workflows

• Done Unit Testing and Deployment activities
• Involved in refreshing materialized views by running scripts
• Prepared Unit Test Cases and executed them
• Involved in Administration activities like creating users, assigning privileges and deployment groups