SUMMARY:

• Over 10+years of IT experience with expertise in analysis, design, developmentand implementation of Data warehouses, data marts and Decision Support Systems(DSS)using ETLtools withRDBMSlike Oracle,MSSQL server, Teradata,DB2 and Snowflakecloud databases on Windows and UNIX platforms.
• Strong experience with Informatica tools using real - time CDC (change data capture) and MD5.
• Experience with Snowflake cloud data warehouseand AWS S3 bucketfor integrating data from multiple source system.
• Highly motivated IT professional, with 8+ years of experience in development, production andstrong background in Database and Data Warehousing.
• Experience in the field of Software Development as Developer.
• Expertise in full Software Development Life Cycle (SDLC) including Software Architecture, Object Oriented programming, Designing & Prototyping.
• Experience in providing client focus application support and in successfully analyzing and resolving the problems in a timely and accurate fashion.
• Good knowledge of Derivatives, equities, fixed income, FX, FIX protocol and trade life cycle.
• Good Knowledge in asset management, cash management, trade finance, Investor & Issuer services, market data and reference data.
• Hands-on development and implementation experience in Big Data Management Platform (BMP) using HDFS, MapReduce, Hive, Pig, Oozie, Apache Kite and other Hadoop related eco-systems as a Data Storage and Retrieval systems.
• Experience in data ingestion using Kafka and Flume.
• Have very good strong analytical, problem solving and documentation skills.
• Have excellent understanding of ITIL processes (Incident management, problem management, Change management, Release management and configuration management)
• Well versed in Reviewing functional requirement specification (FRS), Requirements definition Document (RDD) and system design specification (SDS).
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Acquired in depth knowledge of banking applications technical as well as functional knowledge.
• Well versed with compliance, regulation and market Risk applications like market surveillance, trade surveillance.
• Excellent knowledge in Identify defects and discrepancies and identify the root cause (RCA) by debug or analyzing logs. Provide feedback and recommendation to fix the issue permanently.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Vast experience in designing and developing complex mappings from varied transformation logic like unconnected and connected lookups, source qualifier, router, filter, expression, aggregator, joiner, update strategy etc.
• Actively involved in performance tuning of complex mappings using persistent cache, table partitioning, pipeline partitioning etc.
• Extensively worked with data Analysis, data cleansing, data matching and data conversion capabilities of Informatica Developer (IDQ).
• Experience in all the development phases of data warehouse life cycle involving requirements gathering, analysis, design, development, testing and deployment of code in the data warehouse.
• Worked extensively in whole cycle of DTS/SQL server integration services SSIS Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL
• Experience in Agile and Waterfall methodologies.
• Experience in developing universe using Business Objects Designer as well as creating reports Using Web Intelligence.
• Good work experience on scheduling tool like DAC and database tools like TOAD and SQL developer.
• Expertise in Informatica Administration including Installation, upgrade, Applying Hot Fixes, Configuration, maintenance and troubleshooting.
• Strong working experience in installation of Informatica on LINUX.
• Professional Experience in ETL Architecture usingInformatica PowerCenter9.6.1, 9.5.1/9.1.0 HF 5/9.0.1/8.6.1 HF9/8.5/8.1.1 …etc.,
• Involved in a role as an Informatica Administrator in upgrading the repository database and giving permission to various groups of users and testers.
• Installation and configuration of Informatic servers and client environments.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Build a strong alliance with our various network, UNIX, Storage, and IT architecture teams, involving these teams early to build sound, stable, and supportable Informatica environments across the enterprise
• Create and manage users, groups, folders and ensure appropriate privileges are assigned to the different users.
• Hands on experience using query tools like TOAD, PLSQL developer, SQL Assistant.
• Extensive experience in Banking, Telecom & Healthcare applications.
• Experience in 24X7 on call Production support and preparing procedures / documentation whenever necessary.

TECHNICAL SKILLS:

Data Warehousing/ ETL Technology: Informatica Cloud, Informatica PowerCenter 9.x/8.x, Informatica PowerExchange 10.0/9.x/8.x

Database: Oracle 11g/10g, IBM UD2 DB2, MS SQL Server / 2016, MS Access 2000, MySQL,PostgreSQL, Teradata 13/12/V2R5, Snowflake cloud data warehouse

Data modeling: Erwin 9.1/7.1

Languages: SQL, PL/SQL, XSD, XML, Unix shell scripting

Tools: Microsoft Visio, TOAD, Oracle SQL developer, WINSQL, WINSCP, Secure Shell Client. TOAD, OBIEE 10g, SQL Loader, MS Office, Smart FTP, Ultra Edit, Autosys, Control-M, HP Quality Center, MS Visio, AutosysOperating System

Windows, UNIX

Reports: Cognos 10.0 /9.0, QlikView, Tableau 9/10

Methodologies: Ralph Kimball s Star Schema and Snowflake Schema.

Mythologies: SDLC, Agile

Others: MS Word, MS Access, MS Office, GitHub, HDFS, Hive, HDFS, Impala, Hue

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Sr. Informatica Developer

Responsibilities:

• Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Created mapping to load data into AWS S3 bucket using Informatica S3 connector also populated data into Snowflake from S3 bucket using complex SQL query.
• Extensively involved in the Analysis, design and Data Modeling.
• Parsed the Functional specifications into a Technical document, which would provide an efficient platform for peers for development.
• Developed complex ETL Mappings and Mapletsin Informaticato load data from various sources to Data warehouse. These mappings include the various transformations like Source Qualifier, Look up, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Mentoring the team of 4 technical persons for any technical issues, enhancement to the existing system, fixing the issues in the existing system or new changes.
• Designed multi-dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Generated server-side PL/SQL scripts for data manipulation, validation and provided DDL scripts for creation of database objects such as tables, indexes, views, sequences, object types, collection types and Materialized Views.
• Generated reports of Multidimensional analysis, slice and dice and drill down reports.
• Created, Scheduled and Monitored Batches and Sessions using PowerCenter Server Manager/AutoSys/Crontab
• Environment Participating in weekly meetings, reviews, retrospectives, implementation planning.

Environment: s:Informatica PowerCenter 9.6.1 Power Exchange,Oracle 12c/11g, ServiceNow, PuTTY, Windows7, Shell script, Oracle Business Intelligence (OBIEE) 11.1.1.7

Confidential - Mclean, VA

Sr. Informatica Developer

Responsibilities:

• Develop ETL Jobs using various transformations to handle the Business Logic.
• Preparation of Technical Specification document and Migration Documents.
• Supporting multiple informatica environments.
• Supported database migration activities.
• Understanding the business requirements and preparing the design documents for source to target mapping flow.
• Participated in all phases including Client Interaction, Requirements Gathering, Design, Coding, Testing, Release, Support and Documentation.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Used various transformations like Source Qualifier, Filter, Aggregator, Lookup, Sorter, Expression, Normalizer, Router, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
• Dimensional modeling using STAR schemas (Facts and Dimensions).
• Code deployments across Non-Production and Production environments.
• Provide support on weekend release and change implementation support. Maintain/manage the security aspects and create folders as per the requirement
• Managed day-to-day Informatica administration support like domain, nodes Repository services, Integration services, domain security and privileges.

Environment: s:Informatica PowerCenter 9.6.1 HF1, 9.1.0 HF5, Power Exchange, IBM Infosphere CDC, RHEL 6.9, AIX 6.1, Oracle 12c/11g, Securer CRT, ServiceNow, IdentityIQ, PuTTY, Windows7, Shell scripts, WinSCP.

Confidential - Charleston, SC

Informatica Developer

Responsibilities:

• System migration of Development, Test and Production in the primary data center from virtual machines to physical nodes.
• Gather business requirements and design technical specification documents as per the requirements.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Used various transformations like Source Qualifier, Filter, Aggregator, Lookup, Sorter, Expression, Normalizer, Router, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
• Handled day to day administration activities like create users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository Manager, configuring DB connections, monitoring nodes, Repository and Integration services.
• Coordinate software development, user training, network management and major/minor software installation, upgrade and patch management.
• Scheduled backup scripts for domain and repositories.
• Migration of ETL objects on versioned repositories from DEV to TEST and TEST to Production.
• Provide incident and problem management support for business groups and operations
• Upgraded Informatica from 9.5.1 HF4 to 9.6.1 HF3 and configured services in both PowerCenter and Data Quality.
• Provide support on weekend release and change implementation support. Maintain/manage the security aspects and create folders as per the requirement
• Managed day-to-day Informatica administration support like domain, nodes Repository services, Integration services, domain security and privileges.
• Configured relational connections and managed security and privileges.
• Monitor and maintain records of system performance and capacity to arrange vendor services or other actions for reconfiguration and anticipate requirements for system expansion.
• Managed backup and recovery of the domain metadata and appropriate shared file directories.
• Granting privileges to various groups of users and maintain security on Linux OS level.
• Coordinating with different teams like DBA, Network and Linux admin team to troubleshoot the various issues.
• Participated in daily stand-up meetings, reviews, retrospectives, release planning and other Scrum related meetings.

Environment: s:Informatica PowerCenter 9.6.1 HF3, Data Quality, RHEL 6.7, Oracle 11g, CFT, Tumbleweed, Data Guard, Samba, PuTTY, FileZilla, Windows7, Shell scripts, CyberArk, Cherwell, IRS, WinSCP

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• On-Call support: Level-1 support for varied B1 applications (OBIEE, HEM).
• Primary role is to perform all OBIEE Admin activities and secondary is the provide admin support
• Oracle SR management and resolution with the help of Oracle Support team using Oracle Support Secondary ID.
• Scheduled and unscheduled application maintenance activities.
• Add and update ODBC and TNS entries. Monitoring the Jobs and sever space availability and CPU Process.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Involved in code migration release activities.
• Setup and Administration support to OBIEE. Modeling and Development of OBIEE Dashboards using Administration tool.

Environment: DAC, OBIEE 11, Cognos 10, Informatica 9, Sun Solaris and Linux, Windows-2000 and Oracle V11

Confidential, Tampa, FL

Informatica Developer

Responsibilities:

• Responsible for investigation, characterization, and communication of build and release problems.
• Ensure proper configuration of the Power Center Domain components.
• Ensures proper application of the licensing files. Creating Folders and manages user and user group access to objects
• Add and update ODBC and TNS entries. Monitoring the Jobs and sever space availability and CPU Process
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Expected to take control and responsibility for Dev, QA, and production environments while guiding the Users in the best practices of the software.
• Involved in OBIEE and OBIEE publisher patching activities.
• Refresh the Pre-prod environment for OBIEE and Informatica with Production to sync up the changes, every 2 months and prepared the document for the same.
• Release document reviews and involved release activities in PROD and Pre-Production environments.
• Worked for Informatica admin release activities.
• Trouble shooting OBIEE and Informatica issues.
• Troubleshooting SSO related activities, handling access requests to users.
• Monitoring DAC loads and troubleshoot DAC failures and Involved DAC deployment release activities
• Being proactive in identifying and preventing resource bottlenecks, and to position Ourselves early to prepare for resource upgrades to meet the growing needs of ourBusiness
• Creating SR to Informatica Inc- related to any Power center product issues
• Build a strong alliance with our various network, UNIX, Storage, and IT architecture teams, involving these teams early to build sound, stable, and supportable Informatica environments across the enterprise.
• Migrating the RPD and Web CatLog from Development environment to Pre-Prod and Prod
• Requires full knowledge of Supervalu’s enterprise wide Informatica UNIX / LINUX folder structures, folder access flexibility, security access, disk storage concerns.
• Preparing standard operating Procedures for related Informatica issues. Preparing weekly and Monthly progress report.

Environment: Informatica Power Center 8.6.0/8.6.1/ , DAC, OBIEE 10.1.3.4, SUN SOLARIS and Linux, Windows -2000 and, Oracle V 11