PROFESSIONAL SUMMARY:

• Having 10+ years of experience in Software Design, Development, Administration, Testing and support along with Analysis and Implementation of Data warehouse - Business Intelligence applications in various domains like Banking, Insurance and Health Care.
• Expertise in ETL (Extract Transform Load) using Informatica PowerCenter 9x/10x. Worked as both Developer and Administrator .
• Installed Informatica and configured for High Availability and set up GRID environment.
• Configured and managed Domain, Nodes, Repository Services, Integration Services, User Accounts and performed upgrades, backup and recovery.
• Heavily worked on Informatica Mapping Development and used regular as well as advanced transformations like SQL, XML Parser and Java Transformations etc.
• Designed CDC, Recovery and Restart process for ETL Runs.
• Expertise in using RDBMS like Oracle 11g/12c, DB2 9.7 LUW and expertise in PL/SQL and writing Stored Procedures, Functions etc.
• Did performance tuning at both DB level and at Informatica level by using Partitioning techniques, PDO, Tuning SQL, Tuning Transformations etc.
• Strong Experience in UNIX shell scripting and using job scheduling tools like Autosys .
• Good Data modelling experience (mainly Dimensional modelling) and involved in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modelling using Erwin/ER Studio .
• Proven expertise in Production/Application Support and Enhancements of complex real time, business critical applications on Informatica, PL/SQL and UNIX.
• Used Reporting tools like COGNOS, OBIEE and Qlikview for validating data in Reports and as well as debugging.
• Experienced with Agile and Sprint methodologies. Served as a technical lead for an Agile team and actively participated in all Agile ceremonies including planning, grooming, product demonstration and team retrospectives.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.x/9.x, IDQ, DVO

Programming Languages: PL/SQL, UNIX Shell Scripting, Core Java

Databases: Oracle 11g/12c, DB2 9.7 LUW, PostgreSQL, Greenplum

Data Modelling: Dimensional Data Modelling, Star Schema, Snow-Flake, Physical and Logical Data Modelling, ER Studio, Erwin

Scheduling Tools: Autosys, Tivoli

SQL Editors/Other Tools: TOAD, DBArtisian, Sqldeveloper, DBeaver, DataGrip, IntelliJ, Pycharm,Putty, GoldenGate, IBM ClearCase, ClearQuest, Perforce, Putty, HP Quality Center, ALM, SharePoint, Jira, ServiceNow

BI and Reporting Tools: COGNOS, Qlikview, OBIEE, Business Objects

Other knowledge: AWS, DevOps, Agile

PROFESSIONAL EXPERIENCE:

Informatica Lead

Confidential, Fairfax, VA

Responsibilities:

• Lead Data Migration effort from legacy application to modernized application using Informatica suite of products mainly PowerCenter, IDQ and DVO.
• Did Informatica Administration. Installed Informatica 10.2.0 on RHEL EC2 servers and configured for High Availability and set up in GRID environment.
• Created Repository, MRS, DVO and Integration services and managed users and ensured smooth running of Informatica and automated repository back up.
• Designed and Architected ETL flow for Data Migration by creating staging area and implemented Recovery and Restart process for ETL.
• Developed Informatica Mappings and transformation logic by using the Designer Tool to migrate data from Oracle to PostgreSQL.
• Worked with the Source Qualifier, Lookup, Expression, Router, Filter, Update Strategy, Stored Procedure Transformation, Joiner, SQL and other Transformations.
• Converted legacy Oracle data to JSON files using Developer Tool and Data Transformation.
• Constructed Versioning from Legacy OLTP system while migrating Data to new system.
• Developed Reconcile Report to check and compare counts between source and target using Informatica.
• Designed a process to integrate ETL code migration and execution into DevOps pipeline for Continuous Integration and Continuous Delivery.
• Automated ETL Testing by using Data Validation Option to compare Data between Oracle and PostgreSQL after migration.
• Developed Informatica Mappings for full loads and incremental loads between OLTP and ODS and to generate Extracts from ODS.
• Participated in the walkthroughs of the data models, ETL specifications, followed Agile methodologies, used JIRA for tasks tracking and gave Demo to client on progress during end of every sprint.
• Worked with product owners and other development team members to determine new features and user stories needed.

Environment: Informatica PC,IDQ,DVO 10.2.0, Oracle 12c, Postgres 10.x, UNIX, Cognos 10x/11xAWS, Git, Jira, Jenkins

Senior Informatica Developer

Confidential, Hoboken, NJ

Responsibilities:

• Implemented BIAPPS 7.9.6.4 Human Resource Analytics for PeopleSoft 9.1 source system.
• Extensively involved in creating client specific custom reports pointing to Taleo, PeopleSoft HCM & custom CSV files.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Expertise with both connected and Un-Connected Lookups, Reusable Transformation, Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations, extensively used SQL Override function in Source Qualifier Transformation.
• Created custom mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.
• Involved in designing custom ETL mapping to extract Recruitment information from Taleo and Workforce, Compensation & Performance Management sourcing from PeopleSoft HCM.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.

Environment: Informatica PC 9.6.1, Oracle 11g, UNIX,OBIEE 11g, Peoplesoft 9.1

Informatica Developer

Confidential, New York, NY

Responsibilities:

• Mainly involved in ETL Developing using DB2 and Informatica.
• Created stored procedures to populate tables.
• Did performance tuning to existing stored procedures and mappings.
• Used Push Down Optimization techniques to improve performance.
• Used DB partitioning like Hash partitioning and data partitioning techniques like MDC and Range Partitioning for better performance.
• Generated XML files using Informatica for downstream systems.
• Worked with analysts, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the data according to the business logic.
• Helped in creating reports/dashboards using Qlikview.
• Created and scheduled jobs through Autosys scheduling tool.
• Prepared High-level and Low-level design documents and did peer reviews.
• Developed reconciliation jobs which compares data between source and target.

Environment: Informatica 9x/8x, DB2 LUW 9.7, ERWIN 7.2, UNIX, Qlikview, Autosys

Informatica Developer

Confidential

Responsibilities:

• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookup, Dynamic Lookup, Source Qualifier and data flow management into multiple targets using Router transformations.
• Created Sessions & Workflows to run the mappings using Workflow Manager.
• Created Stored Procedures & Functions for data transformation purpose.
• Involved in gathering requirements and created design documents and mapping documents.
• Performed data validation tests using complex SQL statements.
• Worked on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.

Environment: Informatica 9.0.1, SQL Developer, Toad, Oracle database 11g, Unix, XML.

Informatica Developer

Confidential

Responsibilities:

• Worked on Informatica tools Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.
• Developed Informatica mappings and tuned them for better performance.
• Extensively used the Expression, Aggregator, Filter, Joiner, Sorter, Rank, Union, Router, Lookup transformations.
• Extensively used ETL to load data from flat files.
• Designed and Deployed UNIX Shell Scripts.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the Workflow processes using Unix Shell Scripts.
• Used Power Exchange to source copybook definition and then to row test the data from data files, VSAM files.
• Generated SQL Loader scripts and Shell scripts for automated daily load processes.

Environment: Informatica 8.6.1, Oracle11g, XML, XSLT, Stylus Studio, Java, Eclipse