SUMMARY:

• 12 + years of Dynamic, Result oriented IT industry experience in Business Analysis, Application Design, Data Modeling, and Development, Implementation and Testing Data warehouse and Database applications for Financial, Pharma, and Insurance (Health/Property & Casualty) Domains.
• Experience in implementing data warehousing tools including Informatica, Pentaho, data modeling tools like Erwin.
• Expertise in Data Warehousing ETL using Informatica PowerCenter 9. x /8.x/7.x/6.x, Pentaho 5.3
• Complete understanding of Lambda Architecture for designing Big Data Applications
• Experience working in Hadoop ecosystem(HDFS, Hive, Pig, Sqoop, Oozie) using different distribution like Cloudera, Hortonworks
• Experience with Informatica Designer, Source Analyzer, Warehouse Designer, Repository Manager, Repository Server Administration Console, Server Manager, Workflow Manager, Workflow Monitor.
• Experience in Designing systems using Star and Snowflake schema using dimensional modeling for various data Marts that involved various fact tables and multiple dimensions.
• Experienced in Performance tuning of Database, Informatica Processes, and Informatica repository.
• Proficient in OLTP/OLAP System Study Analysis, E - R modeling, Star schema and Snowflake schema dimensional modeling techniques.
• Data modeling experience using Dimensional Data modeling, Star Schema modeling, Fact & Dimension tables, Physical & logical data modeling using ERWIN 4.0/3.5.
• Strong in writing SQL Queries, testing and debugging Queries.
• Extensive experience in writing PLSQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.
• Have expertise over Business Intelligence and Datawarehouse Concepts.
• Experience in various Data sources like Teradata, Oracle, SQL Server, SAP, DB2, Siebel, Flat files.
• Knowledge in Core Java
• Good experience in writing shell script in Linux, UNIX shell, Ksh, Awk, Sed and Perl scripts.
• Good Communication and Interpersonal skills, self-starter, good Team Player and pro-active team leader .
• Ability to learn and adapt new technologies quickly.

TECHNICAL SKILLS:

Data Warehousing: Pentaho 5.3, Informatica PowerCenter 9.6/9.5/9.1/8.6.1/8.5/8.1.1/8.0/7.1.2/7.0/6.2/5.1 (Source Analyzer, Informatica Power Mart 6.2/5.1 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server, PowerConnect, Power Analyzer, ETL, Cobol, Siebel Warehouse 6.3, Siebel 7.0/2000/5.5, Metadata, Data Mining, Datamart, OLAP, OLTP, SQL* Plus, SQL*Loader.:

Data Analysis: Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, HIPAA (4010A1x & 005010x), Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis:

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0/3.0, Oracle Designer:

Business Intelligence: Cognos Series 7.0, OBIEE, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), MS Access Reports:

Big Data ecosystem: Hadoop(HDFS, MapReduce), Hive, Pig, Sqoop, Oozie, impala, Spark, Elastic Search:

MPP Databases: Teradata V2R6/V2R5/V2R4/14.10, BTEQ, Fast Load, Multi Load, Fast Export, T-Pump:

Databases: NoSQL Database(HBase, MangoDB, Cassandra) IBM DB2 UDB 8.0/7.0, Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2008/2000, Teradata 12/10/2.4, DB2, Unix Shell Scripting, SQL, PL/SQL, MS Access:

Others: Unix Shell Scripting, Autosys, Control M, SQL Navigator, Visual Basic 6.0/5.0:

Environment: IBM AIX 4.2/4.3, OS/390, Linux - Red Hat 6.5, CentOS, Sun Solaris 2.6/2.7, Windows:

PROFESSIONAL EXPERIENCE:

Confidential, DE

Sr. Application Developer

Responsibilities:

• Designed, coded and led development of application components in Agile Methodology working in test-driven and highly iterative environment.
• Driving stand up calls using Kanban board in agile environment in the position of scrum master.
• Expertise in handling PM tools such as JIRA, Clarity.
• Leading critical projects and seeing them to successful implementation under intense time lines.
• Involved in building Data Lake in Big Data using Cloudera Distribution.
• Built end-to-end ETL processes in Pentaho & Informatica to ingest, transform, and publish highly refined analytical data sets
• Working with MPP Databases (Teradata, Greenplum) for extracting or loading data as per needs.
• Constructed data models for ingest ing data, built aggregate tables to support high performance reporting in Hive.
• Work ed to facilitate creation of high performing data centric components and applications .
• Work ing Closely with Business Users in understanding and solving business problems
• Experience in importing and exporting huge volumes of data using Sqoop from EDW(ICDW) to HDFS to Analytical Relational Database Systems and vice-versa.
• Performed Data analysis on Hive tables using Hive queries (ie HiveQL)
• Good experience in Hive partitioning, bucketing and perform different types of joins on Hive tables and implementing Hive SerDes like REGEX, JSON and Avro.
• Experience in developing customized Hive UDFs and UDAFs in Java, JDBC connectivity with hive development and execution of Pig scripts and Pig UDF's
• Experience in validating and cleansing the data using Pig statements and hands-on experience in developing Pig MACROS.
• Used Oozie to automate MapReduce, sqoop, hive and pig jobs that process the data on a timely manner. Used Control M for scheduling Pentaho Jobs
• Heavily coded in BASH script to execute ELT Process in Linux/Unix platform

Environment: Hortonworks/Cloudera Hadoop, Hive, Pig, Sqoop, Oozie, Spark, Pentaho 5.3, Informatica 9.5, Greenplum 4.3, Teradata 14.10, Control M Scheduler, PGAdmin, Teradata SQL Assistant, Red Hat6.5, JIRA

Confidential, NJ

Sr. ETL Informatica Lead

Responsibilities:

• Worked closely with the Applications Development and Project Management teams coordinating, scheduling and implementing.
• Lead different critical projects from Inception, Design, Development, Unit/Integration Testing, Implementation, Maintenance covering all Phase of SDLC
• Wrote High Level & Technical Design Documents based off of Business Requirement Documents & Technical Requirement Documents
• Loading and transforming large sets of structured, semi structured and unstructured data
• Managing data coming from different sources
• Create/Maintain database stored procedures, functions, packages, views, types, tables.
• Created reusable transformations and mapplets to use the transformation logic in multiple mappings.
• Various Informatica transformations like XML Source Qualifier, XML Generator, XML Parser, XML Target, Web Services(Consumer Webservice), Java Transformation, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator etc.. Were used as per needs in an efficient manner.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Responsible for performance fine-tuning of SQL queries for better performance.
• Extracting data from different sources like Oracle, SQL Server, Mainframe Files(in EBCDIC format), XML Files, Flat files transformed & Loaded the data based on Business requirements and loading into Enterprise Data Warehouse
• Created Data maps, Extracted data from Mainframe File using Informatica Power Exchange.
• Developed process to perform Control & Balance which help in loading quality data.
• Wrote reusable shell scripts using grep, awk, sed… for easy maintenance
• Involved in SIT Support, UAT & Production Support.

Environment: Informatica 9.5/9.1, DT, IDQ, IDE, AIX UNIX, Windows, Toad for DB2 10, Oracle SQL Developer, Tivoli Scheduler, Oracle 11, SQL Server 2008 DB, Toad for DB2, Linux CentOS

Confidential, PA

Sr. ETL/Big Data Developer

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements.
• Worked with the Systems Engineering team in setting up Hadoop ecosystem with 8 node Cluster .
• Developed scripts in Java MapRecduce and Hive for processing data of customer viewing preferences and social media comments which will be used by Big Data analytics platform.
• Solely responsible for Analysis, Build, Unit Testing and deploying mappings and objects using Informatica.
• Designed incremental load processes and aggregate processes, achieving best performance load times.
• Coordinating with source system owners and Involved in day-to-day ETL process monitoring, and maintenance.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Extensive use of SQL Loader for migration of data from Flat File to Oracle.
• Designed/Created the plan for the Master workflows that are to be scheduled to run on daily and monthly basis.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem troubleshooting.
• Migrated code to test Environment and involved in support of QA Testing.
• Created the Production Support Document and assisted the Production Support Team with all the production related issues.
• Fixed defects and performance problems discovered in testing and solved the issues raised during Regression Testing.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules

Environment: Informatica 8.6.1, Erwin, AIX UNIX, Windows, Oracle 10g, Oracle SQL Developer, Autosys, XML, Oracle Linux, Hadoop, Hive, HBase.

Confidential, NJ

Senior ETL Informatica Developer

Responsibilities:

• Wrote Technical design documents after thorough understanding of BRD/TRD and data profiling using Informatica’s IDE tool. Involved in writing mapping documents after sitting with Business Analysts
• Designed efficient Informatica mappings, developing reusable objects and Parameterizing values for high performance processes and less maintenance code
• Involved in Understanding requirements, designing, developing and delivering multiple project simultaneously
• Understands Informatica’s Velocity methodology and implemented the standards which helped in efficient and easy maintenance.
• Extracted data from VSAM files using Informatica Power Exchange
• Wrote efficient SQL statements in Oracle, SQL Server and DB2 Data bases.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Wrote reusable UNIX scripts (using AWK, Sed, Perl, Grep) for moving incremental files, Data Validations, generating reports.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Designed and developed several PL/SQL procedures/functions in SQL Server which are used by Informatica Store Procedures Transformations and data was used to help Auditors.
• Tasked to review and evaluate proposed system design resolutions (such as table structure, table relationships, Informatica Mappings Designs) and determine feasibility and practicability in real time environment.
• Ensured timely completion of development projects within estimated costs and standards.
• Experienced on the tasks required to establish, to a high degree of assurance, that a system is performing its intended functions according to pre-defined specifications
• Involved in data analysis (Using IDE), Prototype Development (POC), ETL & Reporting system design and user training.
• Daily interaction with offshore teams and coordinated between onsite and offshore for timely delivery of projects
• Improved performance by optimizing and tuning database objects, reports and ETL processes.
• Performed Unit, System and Integration testing.
• Provided Production Support as and when needed and available on 24/7 support
• Developed the scheduling and automation of jobs using Shell Scripts
• Developed FTP process to extract data from Flat files received from various systems.

Environment: Informatica 8.6.1(Power Exchange, Power Center), Informatica 9.1, Erwin, DT, IDQ, IDE, AIX UNIX, Windows, Toad for DB2 5.x, Oracle SQL Developer, Microsoft SQL Server 2008 Tivoli Scheduler, DB2 v 9.5, and Oracle 11g

Confidential, NY

Senior ETL Developer

Responsibilities:

• Involved in Analysis and designing Technical Design Document (TDD) of CMS (Campaign Management System) related campaign loads into CAE from CIR.
• Gathered Business requirements/reports in effectively designing the database in providing data at differently layers.
• Involved in ETL Development using Informatica of CIR loads from Files (SFI files) provide by vendors.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Extensively used TPT loader and Relational loader in loading data into Teradata DB tables.
• Extensively/Efficiently used different Informatica transformations (connected/unconnected Lookups, Filter, Router, Sorter, Aggregator, Joiner, Expression, Stored procedures, Normalizer, Update strategy and Rank) in loading data effectively into Warehouse.
• Tuned existing mappings, targets, sources, sessions and SQL queries to improve the performance.
• Extensively created and used Source/Target definitions their shortcuts, mapplets, worklets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Used command task, email task and decision tasks based on user requirements.
• Involved in Writing Shell scripts in performing data validations on input data files
• Production issues were resolved as and when assigned.
• Used FTP in transferring SFI files into Informatica Server prior to loading data
• Performed Unit Testing and tuned for better performance.
• Wrote IT test plan and involved into IT testing
• Involved in QA testing as a part of deliverable.

Environment: Informatica PowerCenter 8.6, Teradata 12, Oracle10g, Erwin, Autosys, Toad 9.5, Linux, Windows XP, MS Visio.

Confidential, NY

Senior Informatica Developer

Responsibilities:

• Solely involved in Analysis, designing Functional Design Document (FDD), development, deploying and testing of data warehouse environment implemented on Teradata database.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Developed in ETL Processes using Informatica 8.6 in modular development for reusability purposes.
• Performed Informatica Admin operation which involves Source definitions, Target definition mappings, workflow and other Informatica objects migrations from one environment to other environments.
• Extensively used Teradata loaders (Fast Load, Multi Load, and TPump) for high performance.
• Extensively used connected/unconnected Lookups, Filter, Router, Sorter, Aggregator, Joiner, Expression, Update strategy and Rank Transformations
• Tuned existing mappings, targets, sources, sessions and SQL queries to improve the performance.
• Extensively created and used Source/Target definitions their shortcuts, mapplets, worklets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Used mapping parameters, mapping variables, session parameters and parameter files on different mappings and sessions, based on various business requirements for Incremental loads.
• Extracted data from different source systems like Oracle, DB2, Flat Files, Legacy Systems (VSAM files).
• Used command task, email task and decision tasks based on user requirements.
• Involved in Writing KShell scripts for PRE and POST Session, for generation of Parameter file on the fly for Incremental loads etc…
• Efficiently followed SLDC process to meet SOX standards
• Extensively used Informatica Power Exchange for Siebel
• Involved in fixing the PRODUCTION issue when assigned
• Extensively used SFTP(Secure FTP) for transferring the secure data files between one system to another
• Performed Unit Testing and tuned for better performance.
• Wrote IT test plan and involved into IT testing.
• Provided supporting to QA testing.

Environment: Informatica PowerCenter 8.6/7.1.3, Teradata V2R6.2, DB2, Oracle10g, Siebel, Flat Files, Omni, Siebel, JCL, Autosys, Toad 9.5, UNIX, SQL Server, windows XP MS Visio, OBIEE.

Confidential, NJ

Senior Informatica Developer

Responsibilities:

• Developed various mappings, which extracts data from OLTP Oracle, SAP, Flat files into target tables to simplify business process across organization via single platform.
• Created Technical Design Document (TDD) for every mapping created.
• Established modular development strategies to expedite development and simplify maintenance.
• Involved in designing Star schema by de-normalizing database tables.
• Build common exception handling process to enable verification and validation capabilities and provide necessary audit functionality.
• Responsible for resolving production issues of different workflows.
• Used Debugger and Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions
• Developed Shell scripts to parse and split flat data files into multiple data files for use by Source Qualifier. Also developed Shell/SQL commands to load reference data.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, target based commit interval.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Participated in Technical, and Code review meetings as the mappings are developed and tested
• Created several mappings using various Informatica Transformations: Lookups, Update Strategy, Aggregator, Source Qualifier, Joiners, Ranks, Sorter, Expression, Filter etc.
• Created different tasks like command, worklet, decision, event raise, and event wait etc and used them in Workflow design in Workflow manager.
• Developed Mappings for Summary Tables using SQL and Informatica’s Aggregator Transformation.
• SQL Tuning using Explain Plan, SQL Trace, Gather Table Stats.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions
• Performed Unit testing and Coordinated with the QA team while testing in QA environment
• Created different tasks like pre-session sql, post-session sql, email and designed Work flow manager.

Environment: Informatica PowerCenter 8.1, Oracle10g, ERWIN 4.0, Cognos, Toad 9.5, Autosys and UNIX

Confidential, NC

Informatica Developer

Responsibilities:

• Involved in Analysis, development, deployment and testing of ETL process for into warehouse environment.
• Tuned existing mappings, targets, sources, sessions and SQL queries to improve the performance.
• Extensively created and used Source/Target definitions their shortcuts, mapplets, worklets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Used mapping parameters, mapping variables, session parameters and parameter files on different mappings and sessions, based on various business requirements for Incremental loads.
• Involved in trouble shooting the mapping in cases of PROD Support issue and interacted with Informatica Tech Support in case of failure.
• Performed Unit Testing and tuned for better performance.
• Wrote IT test plan and involved into IT testing
• Involved in setting up the FTP process for file transfer between UNIX boxes.
• Responsible to tune ETL procedures, processes and STAR schemas to optimize load and for query Performance.
• Developed and implemented Error Handling Strategies for ETL mechanism.
• Developed and implemented Migration Strategies for deployment of mappings and objects.
• Created mappings, mapplets using the transformations such as the Source qualifier, Aggregators, Normalizer, Expression, lookups, Router, Filters, Rank, Sequence Generator, and Update Strategy.
• Involved in writing Shell Scripts using Perl to automate the Pre-Session and Post-Sessions Processes.
• Developed shell/awk/Perl scripts to parse and clean data files prior to loading.

Environment: Informatica 7.1.3, Oracle10g, Siebel, Flat Files, Omni, Siebel, JCL, Toad 9.5, UNIX, SQL Server, windows XP MS Visio, OBIEE.