SUMMARY

• 10+ years of experience in full life cycle of software project development in various areas like design, Applications development of Enterprise Data Warehouse on large scale development efforts leveraging industry standard using Informatica PowerCenter, PowerExchanger, B2B, IDQ, and Oracle PL/SQL etc.
• 2+ years of experience using Informatica BDE, Sqoop to provide Big Data solution. .
• Extensive knowledge of business process and functioning of Financial, Insurance, Tele communication and Manufacturing sectors.
• Excellent working experience in Waterfall, Agile SDLC methodologies.
• Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Informatica and designed data conversions from wide variety of source systems including Mainframe/DB2, Oracle, SQL server, Hive, Flat files, XML/JSON files and unstructured data files.
• Expertise in designing ETL processes by following Informatica ETL design patterns and using Informatica transformation, session and workflow components: Lookup, Aggregator, Joiner, Expression, Filter, Router, Update strategy and Normalizer Transformations, Mapplets, reusable session, email, worklet and concurrent workflow etc.
• Expertise in tuning performance of complex Informatica mappings: isolating bottleneck and providing solutions like dynamic partitioning etc.
• Expertise in designing and developing ETL processes in Autosys: developing box, job, dependency and calendar etc.
• Expertise in developing ETL process with PL/SQL: packages, procedures, functions and triggers etc.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAINPLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Strong understanding of processing engine of Informatica and Oracle.
• Strong understanding of data warehouse, data hub and data lake methodology.
• Expertise in Data modeling techniques like Data Modeling - Dimensional/ Star Schema and Snowflake modeling, Slowly Changing Dimensions (SCD Type 1, Type 2, and Type 3).
• Expertise in developing automated QA processes by using Korn shell scripting, Java, SQL etc.
• Expertise in implementing of data profiling, creating score cards, creating reference tables and documenting Data Quality metrics/dimensions like accuracy, completeness, duplication, validity, consistency.
• Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
• Strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
• Experience in HP ALM and QA processes.
• Experience in data profiling with Informatica IDQ and Adastra Ataccama, configuring merging and hierarchy management in Adastra Ataccama.
• Strong Experience with shell scripting, understanding of approaches for business intelligence, data warehouse.
• Java experience using Informatica Java components and core Java.
• Strong problem solving and trouble shooting expertise.
• Self-Starter and Team Player with excellent communication, organizational and interpersonal skills with the ability to grasp things quickly.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Informatica Power Exchanger, Informatica IDQ, Informatica B2B

Operating Systems: Unix, Linux, Windows

Databases: Oracle 11g/10g, DB2 9.x/8.x, Hive, Mysql

Languages: Hadoop, Java, XML, JSON, PL/SQL, SQL, UNIX/LINUX shell programming and scripting, Sqoop

Database Tools: SQL Developer, AQT, SQL developer, SQL Server Management Studio, Toad, SQL*Loader

Other Tools: AutoSys, Hp ALM, Altova XML Spy, SQL *Plus, Putty

PROFESSIONAL EXPERIENCE

INFORMATICA Power Center/ BDE Developer

Confidential, Newport Beach, CA

Responsibilities:

• Participated in all phases of the Enterprise Data Hub Risk Data Aggregate project SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Involved in implementing processes to complete massive initial data profiling and remove duplicate data by using IDQ.
• Created business rules in Informatica Developer and imported them to Informatica PowerCenter to load the standardized and good format of data to staging tables.
• Analysed the Mainframe source data and copybook, developed complex data maps through PowerExchanger.
• Designed and developed end-to-end ETL process to ingest data from various source systems to Hive tables and populate audit tables.
• Designed and developed mappings, mapplets and workflows in Informatica BDE.
• Developed data processors (Streamers, parsers, Serialized and transformers etc) to read mainframe and xml source data through Informatica B2B.
• Developed processes to ingest data from Oracle tables to hive tables through Sqoop.
• Experienced with creating Autosys objects (boxes, jobs, calendars and dependencies).
• Experienced in trouble shooting Informatica product bugs and developing issues.
• Develop application design documents and internal design documents for ETL processes.
• Performed unit testing and support SIT, UAT and code migration.
• Investigated production issues and provided solutions.

Environment: Informatica BDE, Informatica IDQ, Sqoop, Oracle 11g, HADOOP, HIVE, Agile Methodology, Beeline/Hue, TOAD, AIX, Shell Scripts, AutoSys, HP ALM

Senior Informatica Developer

Confidential, Jacksonville, FL

Responsibilities:

• Participated in all phases of the different projects (BASEL3, CDIC, FATCA, AML etc.) SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Developed application design documents and internal design documents for ETL processes.
• Involved in massive data profiling and duplicate data removing using Informatica IDQ prior to data staging.
• Developed complex datampas to read mainframe source data through PowerExchanger and analysed data.
• Designed and developed mappings, mapplets and configured session workflow object properties and parameter files.
• Designed and developed Mappings to populate the data into dimensions and fact tables.
• Designed and developed PL/SQL packages, procedures and functions and triggers.
• Effectively made use of Hints, Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, SQL Loader, Dynamic SQL and Ref Cursor.
• Worked extensively on Exception handling, External Tables and Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Experienced with Performance Tuning for Oracle RDBMS using Explain Plan, INDEX, ROW ID and HINTS.
• Experienced with regression testing for Oracle migration from 10g to 11g.
• Experienced with Performance Tuning for Informatica mappings, sessions and workflows.
• Experienced with creating Autosys objects (box, calendar and jobs).
• Experienced with Shell Scripts programming.
• Performed unit testing and support SIT, UAT and code migration.
• Investigated production issues and provided solutions.

Environment: Informatica PowerCenter 9.0/8.6, Informatica PowerExchange, Informatica IDQ, DB2 Mainframe, AutoSys, Toad, Oracle10g/11g, Windows XP, UNIX, Korn Shell, PVCS.

Senior QA Specialist/ETL Developer

Confidential

Responsibilities:

• Developed automated QA/ETL processes by implementing SQLS, IMPORT, EXPORTS and KORN shell Under AIX.
• Performed functional test and integration test for batch and near real time ETL processes.
• Implemented test cases and execution plan documents.
• Performed code promotion and delivered code for sign off.
• Resolved issues by finding the root causes of issues.

Environment: DB2 v9, KORN SHELL, AQT, WEBSPHERE MESSAGE QUEUE, PUTTY, PVCS, AIX

Senior Informatica Developer

Confidential

Responsibilities:

• Designed and developed mapplets, mappings, sessions and workflows to handle data validation, data extraction and loading data into fact and dimension tables.
• Performed unit test and code review for mapplets and mappings..
• Performed debugging of mappings to find the root cause of the bug in SIT.
• Used various transformations like Source Qualifier, Aggregators, Connected & unconnected lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, etc.

Environment: Informatica PowerCenter 8.6, SQL Server 2005, DB2, SQL Server Management Studio, Windows XP

Informatica ETL Developer

Confidential

Responsibilities:

• Participated in all SDLC phases of the VENICE project from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Analysed existing ETL process by digging into existing mapplets, mappings, sessions and workflows.
• Analysed the Mainframe source data and copybook, developed complex data maps through PowerExchanger.
• Designed ETL processes to handle issues like: Input control, roll back, error handling.
• Designed and developed Informatica mapping by applying mapplets, transformations, variables and parameters etc.
• Configured session properties as strategies to handle issues.
• Designed and developed session and workflow objects.
• Tuned INFORMATICA mappings performance.
• Performed unit testing and support SIT, UAT and code migration.

Environment: Informatica PowerCenter 8.6.1, Power Exchange 8.6.1, Mainframes, Toad, KORN shell, Autosys, putty/WINSCP, Solaris

Informatica ETL Developer

Confidential

Responsibilities:

• Developed Informatica mappings with designer; configured sessions and workflows properties.
• Tuned queries performance for big tables with indexes, hints and temp tables.
• Tuned INFORMATICA mappings performance.
• Implemented queries and KORN shell scripts for unit and integration test.
• Implemented complex queries to dig into detail analysis of issues.
• Documented the INFORMATICA mapping specifications and test results.

Environment: Informatica PowerCenter 8.1, Oracle 9.x, Toad, KORN shell, putty/WINSCP, Solaris

Informatica System Analyst

Confidential

Responsibilities:

• Analysed the source to target mappings of the ETL process.
• Traced ETL processes by analyzing mappings and SQL scripts.
• Implemented system analysis documents.
• Updated existing mappings and implemented new mappings.

Environment: Informatica PowerCenter 7.1, Oracle 9.x, Toad, Perl

Informatica ETL Developer

Confidential

Responsibilities:

• Participated in SDLC phases of the project Base Camp OPS NAS Trouble ticket and NPD from analysis, design, development, testing, implementation and maintenance.
• Modified and implemented oracle packages to handle pre, post Informatica mappings and landing of CMDB sources (external tables).
• Implemented scripts to do data movement and handle table partitions, compression and index issues.
• Implemented test cases for Informatica mappings and performed the unit testing. Tuned queries performance for big tables with indexes, hints and temp tables.
• Performed system integration test.
• Implemented complex queries to dig into detail analysis of test cases.
• Documented the Informatica mappings specifications and test results.

Environment: Informatica PowerCenter 8.1, Oracle 9.x, Toad, KORN shell, putty/WINSCP, Solaris

Oracle Developer

Confidential

Responsibilities:

• Involved in SDLC phases of the project Mutual Fund Corporate Data Warehouse from analysis, design, development, testing, implementation and maintenance.
• Involved in designing and developing extract, transformation and loading processing (ETL) of a mutual fund CDW.
• Developed PL/SQL packages, procedures, functions and triggers to load from pre staging to staging and from staging area to data warehouse.
• Implemented complex bulk insert, update, merge SQL statements and applied hints in store procedures.
• Performed unit test, function test, SIT (System Integration Test etc, and code inspection review.
• Involved in tuning data warehouse performance using appropriate partitions, indexes, materialize views and temp tables etc.
• Maintained, debugged, modified and upgraded all existing ETL PL/SQL scripts.
• Monitored and troubleshoot daily ETL and EOD jobs of corporate warehouse.

Environment: Oracle 10g, KORN script, PL/SQL, SQL*Loader, Solaris

Software Developer

Confidential

Responsibilities:

• Developed four suits of mock tests for the IBM XML certificate.
• Developed six suits of mock tests for the MYSQL Core and Professional certificate.
• Developed three suits of mock tests for the JAVA1.4 SCJP certificate.
• Developed web application with java, XML.

Environment: Java, XML, XSLT, DOM/SAX/JAXP, MYSQL, Windows