SUMMARY

• Over 11 + years of extensive experience in IT Software &ETLtools
• Experience in Insurance, Retail, Banking, Financial and Healthcare Domains
• Proficient in gathering requirements, Integration Architecture, Leading the team, Hands on development.
• Experienced in Informatica Data Quality(IDQ/BDQ), BDM, BDS, EDC, Axon, IICS, ICRT, PC, PWX, MDM
• BuiltIDQ Rule/Mapplets, Mappings for Cleansing, Standardizing, Parsing, Matching, Merging and Enrichment process using Informatica developer tool/IDQ/Big data quality(BDQ), Big Data Masking
• Worked in Informatica Big data Management(BDM/BDE) to process flat files, RDBMS(Oracle, SQL Server), JSON, XML,REST API, AWS Cloud(AWS S3, Redshift, RDS, HBASE - EC2, EMR), Hadoop (HDFS,HIVE, HBASE)using Native, Blaze, SQOOP, Spark, Map reduce modes, Yarn, Cloudera, Ambari
• Programming knowledge in Unix Shell scripting and Python scripts
• Experienced in Integration with Informatica Cloud mappings for Salesforce Applications
• Experienced in Informatica B2B Data Transformation(DT) to process Data processor transformation, semi structured, un-structured file formats and knowledge in B2B Data Exchange(DX)
• Worked with various sources and target in Informatica such as JSON files, Oracle, SQL server, Teradata, Salesforce(SFDC), Sybase, VSAM, DB2, XML, Flat file, COBOL files, etc
• Worked on MDM table configurations, Data mapping for Informatica MDM Landing, Staging and Base objects,Match/Merge rules config, cleansing worked in Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) models in Powercenter
• Good experience in Data Warehouse, Data mart, Dimensional Data Modeling
• Experience in analyzing the existing system, Impact Analysis, understanding the business functionality
• Hands on experience in performance tuning Informaticamappings, debugging, review code, maintain versioning, Unit testing, maintain standards and best practices
• Experience in Install, configuration and Administration of Informatica products on Windows, Unix and Linux
• Worked in Both Agile and Waterfall methodologies method in Software development life cycle(SDLC)
• Excellent Interpersonal Skills with the ability to work independently and with the Team, communication to higher management, stake holders and business owners

TECHNICAL SKILLS

Data Warehousing ETL: Informatica Powercenter, Informatica Big Data Edition(BDE/BDM/BDS), Axon, EDC/EIC, IDL, Informatica Power Exchange, Informatica Cloud,InformaticaData Quality(IDQ/IDE),Informatica MDM Hub,Informatica B2B Data Transformation/Data Exchange, Metadata Manager(IMM),SAP Business Objects Information Design Tool(IDT),Erwin Data Modeler, OBIEE

Mainframe: JCL, COBOL, CICS,VSAM,DB2,IMS,Z/OS

Others: SQL,PL/SQL, XML, JSON, TOAD, SQL developer, Shell scripting, Tidal, Autosys, Teradata Studio Express, Tableau

Environment: UNIX/Linux, Windows (7,XP, NT/95/98/2000)

Databases: Oracle 11g/10g/9i, MS SQLServer 2008,Teradata, IBM DB2UDB, VSAM, IMS, Netezza, Sybase.SFDC(Salesforce) API

PROFESSIONAL EXPERIENCE

Informatica Lead Developer/Architect

Confidential, Warren, NJ

Responsibilities:

• Involved in Requirement Analysis, Designing over all Architecture,Identifying anomalies, Informatica IDQ/BDM Map development and Testing.
• Data migration from on premise databases to AWS cloud Data lake
• Worked in IDQ/BDM for Profiling, DQ rule development(Completeness, Conformity, Consistency, Accuracy), cleansing, standardizing, Parsing, Grouping, Matching, Bad & duplicate exception management to correct Data Quality issues (Human task),Scorecard development,
• Pushdown to Hadoop, Integrated the IDQ scorecard results to Axon Data Governance
• Experienced in data viewer, Columnprofiling, parameter file generation and application deployment.
• Knowledge and experience in Integration with Axon Data Governance and EDC/EIC - Enterprise Data Catalogue on AWS cloud
• Knowledge and experience in Installation, Configuration and Administering the Informatica Big data
• Attended Informatica official Trainingfor Informatica Axon and EDC/EIC

Environment: Informatica Data Quality/BDM 10.2.0/10.2.1 Developer/Analyst, Big Data Streaming (BDS), EDC/EIC 10.2,IMM, Axon 5.4, Powercenter, Amazon Web Services (AWS), S3, JSON, RDS - Oracle, Redshift, HBASE, HUE, SQL Server, Infacmd Batch, Cloudera, Windows 7, Linux/Unix, Unix Shell scripts/Python scripting,Aginity, EC2, EMR, Putty, WinSCP, Data lake

Informatica BDMLead

Confidential

Responsibilities:

• Involved in Requirement Analysis, Informatica BDMMap development and Testing.
• Experienced in Data viewer to view the data in each transformation, validating the code in Native and Hive/Blaze mode, running the mapping, Creating workflow, Application creation and Deployment, Running the workflow using Infacmd command and running directly from mappings, Generation of Parameter files, testing and application maintenance.
• Data migration from SQL Server to AWS S3, S3 to HBASE, S3 to Redshift, Hive tables over S3
• Strong experience in debugging the mapping in Hadoop-Blaze push down and in Native mode.
• Independently developed number of Informatica BDM/IDQ Mappings, Dynamic mappings
• Created mapplets to handle common logics like address validation, Email, Phone validation
• Experience in analyzing BDM logs, YARN, Blaze/Hadoop logs, with and without verbose data mode.
• Created Mapping, Workflow Parameters, Generated parameter files
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

Environment: Informatica Data Quality 10.1.1, Informatica BDM 10.1.1,Big Data Streaming (BDS), Amazon Web Services (AWS), S3, RDS - Oracle, Redshift, JSON, HBASE, HUE, HDFS, Hive, SQL Server, Control-M, Windows 7, UNIX shell/Python scripts,Spark, Tableau,Aginity, EC2, EMR, Putty, WinSCP, Data warehouse, Data Lake

ETL Leaddeveloper

Confidential

Responsibilities:

• Involved in Requirement Analysis, Informatica Map development, Table Creation, debugging, testing and application maintenance.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Involved in Agile Methodology Process, Update the Work Status in Daily Standup.
• Independently developed number of Informatica Mappings.
• Experience in integration of various data sources like SQL Server, Oracle, Flat Files
• Experience in UNIX Operating System and Shell scripting.
• Implemented various projects in production.
• Used Debugger in Informatica Powercenter Designer to check the errors in mapping
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

Environment: Informatica Powercenter9.6, PowerExchange, Informatica Metadata Manager, SQL Server, TFS Visual Studio, Tidal, Windows 7, PL/SQL, UNIX, SQL developer, WinSCP, Scrum, Agile Methodology, Data warehouse, ODS

ETL Leaddeveloper

Confidential, NYC

Responsibilities:

• Involved in all the stages of the Software development Life Cycle development (SDLC).
• Created the Stored procedures, functions in DB and Staged Sproc’s in ETL informatica and Delta/Merge process to load the high volume data.
• Worked on Creating profiles, scorecards, rules in Analyst tool, Building Mapplets, Mappings for Cleansing, Standardizing, De-duping and Enrichment process using IDQ transformations in Developer
• Created Match/Merge rules, Consolidation (BDD/IDD), Human tasks and Application deployment.
• Integrate data quality rules, mapplets and mappings with Powercenter for execution.
• Worked on Creating configurations and Data mapping for MDM Landing, Staging and Base objects
• Implemented various projects in production, Analysis of customer queries and providing resolution
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Worked on Informatica Salesforce Power-exchange/Connector and developed multiple staging jobs
• Created Oracle PL/SQL Scripts, Stored Procedures, Functions and Packages
• Created Teradata Scripts using Utilities BTEQ, Fastload, Multiload, Fast Export, Tpump
• Interacting with end customers to understand the requirement.
• Analyzed Session Logs, workflow log files and Debugging the code to fix the Testing issues
• Created UNIX shell Scripts for Post Session/Pre Session Commands.

Environment: Informatica Powercenter9.6/10.0, PowerExchange, Informatica Data Quality v9.5,Informatica MDM 9.7/10.0, IDD, IDS, JBOSS,SIF,HM,Oracle, Teradata, BTEQ Scripts.SFDC(Salesforce) Powercenter, PowerExchange plug-in, Informatica Cloud (On Demand and Real time),SQL Server,Rapid SQL, Teradata Studio Express, Erwin Data Modeler, Windows 7, PL/SQL, UNIX, SQL developer, WinSCP, Confluence, JIRA, Scrum, Agile Methodology, Data warehouse, ODS

ETL Leaddeveloper

Confidential, Omaha, NE

Responsibilities:

• Involved in all the stages of the Software development Life Cycle development.
• Worked in Informatica Big data Edition(BDE) to process data on Hadoop
• Created Informatica Mappings to write to HDFS and Hive
• Imported Powercenter mappings to IDQ - Model repository (developer tool)
• Redesigned mappings to handle sorting and statefulness in Hadoop
• Processed Inserts, updates by rebuild
• Running mappings via workflow in Native and Hive mode
• Worked on Column Profiling using Hive Pushdown
• Worked in Informatica Cloud mappings on demand and real time for salesforce
• Knowledge in Creating weblog Data Processor, Parser and Serializer
• Implemented various projects in production and did production Support
• Worked in IDQ Standardization, Parser, Grouping, Matching, Identity Matching, Association, Automatic and Manual Consolidation, Address Doctor, Bad records and duplicate exception(Human task),scorecards
• Analyzed Session Logs, workflow log files and Debugging the code to fix the Testing issues

Environment: Informatica Powercenter9.6/9.1, PowerExchange, Informatica Data Quality(IDQ),Informatica BDM/BDE 10.1/9.6.1, Informatica Cloud,, Informatica Metadata Manager.Hadoop,Cloudera, Hive, Salesforce,Teradata, Teradata Utilities - TPT,MLOAD, Oracle 11g, SQL Server,DB2UDB,Rapid SQL, Teradata Studio Express.Erwin Data Modeler, SAP Business Objects (IDT),Hyperion, PL/SQL, Unix Shell scripts, SQL developer, WinSCP, Remedy Change management, Confluence, JIRA, Scrum, Agile, Data warehouse, ODS