SUMMARY

• 11 years of IT experience with wide range of experience in software development, Oracle PL/SQL Development, Data Integration and Data Warehousing.
• Experience working with different stakeholders including business analysts, data architects, Web, UI & Report developers, QA & Performance testers and product owners.
• Strong experience in writing Oracle PL/SQL Stored Procedures/Functions/Packages and anonymous blocks. Experience in creating DB objects and writing PL/SQL code for web application usage.
• Extensively worked in Ref Cursors, Triggers, Partitioned tables, Oracle Functions, Triggers, Materialized views, Oracle Objects.
• SQL Tuning by generating Explain Plan and analyzing it to identify bottle necks. SQL hints for better query plan and indexing for faster table access which leads to better query performance.
• Strong experience in Extraction, transformation and loading (ETL) of data from various data sources into data store(ODS) and reporting database using Informatica Power center tools - designer, workflow manager, workflow monitor and Informatica developer.
• Experience in creating Transformations, Mappings and Mapplets using Informatica Designer, Informatica developer and processing tasks using Workflow Manager to apply business logics to move data from multiple sources into targets.
• Extensively worked on development of various ETL mappings in Informatica designer to load the data from various source systems into the Data store and warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Router, Java, Lookup, Sequence Generator, Filter, and Sorter.
• Experience in using Informatica power exchange connection for reading Mainframes DB2 datasets and experience in developing XML/XSD as a part of Source XML files for Informatica.
• Experience working in different phases of Data Warehouse Life Cycle including source system analysis, ETL design/development, project deployment, production support
• Experience testing Database code, ETL Informatica mappings and other ETL batch Processes for functionality and performance.
• Strong ability to analyze source systems and business requirements, identify and document business rules.
• Good understanding of Dimensional Data Modeling like Star schema and snowflake schema.
• Good knowledge of Entity-relationship concept, facts & dimension tables and slowly changing dimensions.
• Experience working with high volume data sets from various sources like Oracle, DB2, XML files, flat files and Hive.
• Expertise in UNIX Shell Scripting, automation of ETL batch processes using UNIX shell scripting. Experience working in Python scripting for automating repetitive processes in SDLC.
• Experience working with Control-m for scheduling Informatica and DB batch jobs.
• Have good experience in Integration, Migration, Conversion and Data projects
• Worked in both Agile and Waterfall methodology with good knowledge of all process, terminologies and ceremonies of both methods.
• Experience working with cross - functional agile team structure.
• Experience working in an onsite-offshore structure and effectively coordinating tasks between onsite and offshore teams. Strong client facing skills, understanding client requirements and proposing product features/enhancements.
• A highly motivated self-starter and a good team-player with excellent verbal and written communication skills including experience in presentation skills.
• Excellent analytical and logical skills with a good understanding at the conceptual level and possess strong interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/10, Informatica Developer

Databases: Oracle 11g/12c, DB2

Languages: PL/SQL, Unix Shell Scripting, Python Scripting

Code control and migration: GIT Stash, Source Tree, Jenkins, IBM uDeploy

Other Tools: PL/SQL and SQL developer, SQL *Plus, SQL *Loader, Putty, FileZilla, Win Merger, Atlassian Jira, Confluence, HP Quality Center

Operating Systems: UNIX (Sun Solaris, AIX), Linux and Windows 10/7

Schedulers: Control M, Unix Corn

PROFESSIONAL EXPERIENCE

Confidential, Durham

Senior Oracle and Informatica Developer

Responsibilities:

• Working with Business Analysts and Data Architects in analyzing business requirements, specifications and business requirement documents in order to define the optimal solution and identify responsibilities for delivering solutions for data loading and maintenance.
• Participated in user meetings, gathering business requirements and translating user inputs into technical specification documents.
• Extensively created Stored Procedures, Functions and Packages used in batch jobs and also those used by web development teams.
• Worked on developing the mappings, mapplets, workflows, worklets using Informatica 10.1.
• Extensively used transformations like source qualifier, lookup, router, Java, filter, expression, Aggregator, sequence generator, sorter, rank etc. to load the data from various sources.
• Developed, Modified and Tested UNIX Shell scripts for automation of events, File Validation, File Archiving.
• Supported sqoop batch jobs that load data from Hive to Oracle • Working in Agile Model of 2 weeks’ sprint.
• Using Control M to monitor/schedule the batch jobs.
• Creating mapping documents with various transformations required as per the system requirements, for various sources like files, DB2 tables, Oracle tables, XMLs.
• Conducting and participating in story grooming sessions to collaborate with technical teams and product owners.
• Preparing detailed scenarios and use case documents for easy understanding, which also helps QA to prepare effective test cases.
• Work with data analyst for the DB schema changes required as per the requirement and to get any new data elements that is required.
• Document edge case data scenarios encountered by development team and modify data mapping accordingly. Cascade the changes based on edge data scenarios to all other places in the system, as per the impact analysis results.
• Work with source team systems analyst and data analyst to understand their data before converting/mapping that to asset management tool requirement.
• Collaborated with cross-functional application teams to make the integration happen and answer all the questions around requirements.
• Reviewing the technology deliverable against the requirements at each epic/story level.
• Suggesting viable solution based on the system knowledge and set expectations from each story.
• Helped team members in critical performance tuning and batch job redesign to meet SLA.

Environment: Oracle 12C, Oracle 11G, Informatica Power Center 10, Linux, UNIX Shell Scripting, Control-MAtlassian Jira, Confluence, Git Stash, Source control, Jenkins, IBM uDeploy

Confidential, Durham

Senior ETL batch Developer and Systems Analyst

Responsibilities:

• Participated in requirement gathering sessions, working with system analyst to understand the requirements.
• Oracle performance tuning by query tuning, query rewriting, design change for long running jobs and high-volume jobs.
• Created Informatica batch jobs to get data from external sources via file and transformed the data by pivoting using normalizer transformation, as required by the application. • Did code version control in Informatica Powercenter repository
• Create and fix Oracle stored procedures, packages and views that will be called by front end teams for web focus reporting and UI display.
• Developed shell script based informatica code review tool that will validate the informatica code against the standard properties and values to avoid any manual overlook of standards.
• Created batch equivalent of existing business flow and made sure the new code is restart able, as it must process bulk data in nightly batch.
• Worked on test data preparation, test case execution and bug fixing.
• Technical analysis for effort estimation and setting milestones.
• Created Functional Specification and involved in design of new and complex high-quality performance solutions to clients in response to varying business requirements.
• Performed deep analysis to understand the impact caused by new jobs on existing batch cycles, applications and documentation.
• Preparation of technical design documents, code review and test case review.
• Outlining performance unit testing approach plan based on the need.
• Co-coordinating the team and was involved in prioritizing and assigning work. Providing technical solution and supports have been part of his role and are the responsibilities taken up by him in this role.
• Production support, on call, non-prod cycle maintenance.
• Collaborated with cross-functional application teams to come up with design.
• Planning and conducting knowledge sharing sessions on each application for the benefit of new entrants to team.

Environment: Oracle 11G, Informatica Power Center 10 & 9.1, Repository Manager, Designer, SQL*loader PL/SQL, SQL, UNIX and Linux, Shell scripting, Control-M

Confidential

Informatica and Oracle Developer

Responsibilities:

• Understanding Business Requirements and High-Level Design.
• Impact Analysis for the program changes and creation of Technical specification document.
• Creating and maintaining various types of Slowly Changing Dimensions (SCD) tables like type 1 to 4.
• Development and testing of Informatica Mappings, Workflows, Developer mapplets for data quality checks. Used Informatica monitor for job execution statistics.
• Worked on Enhancements and new development of Informatica mappings that involves various transformations like aggregator, router, rank, union, lookup, SQL, Sequence Generator, and Stored Procedure etc. as per Client requirement.
• Creating and testing Oracle procedures, functions, anonymous blocks used in batch jobs.
• Creation and maintenance of automation scripts like feed file validation written using unix shell scripts.
• Developed Linux cron jobs for miscellaneous batch activities and UNIX/Control-M cyclic jobs.
• Used oracle sql loader for data loading from files.
• Wrote Packages and number of SQL queries to achieve the complex business functionality with optimal performance for batch job usage.
• Performed Unit testing in Oracle exadata Database. Created Linux Scripts for batch job execution and Scheduled Informatica Jobs using Control-M.
• Identified and fixed issues, defects after detailed research.
• Offshore coordination, assigning and getting task done, reporting status.
• Enabling system analyst to complete their mapping documents and system design specification by providing required technical details.
• Integration and validating the various sub tasks done by team members.
• Involved in design and review calls, Unit testing and testing support.
• Creating RTC tasks, tracking, code control using RTC, code build/packaging and deployment.
• Managed team members in the track by providing KT and Technical assistance.

Environment: Oracle 11G, Oracle Exadata, Informatica Power Center 9.1, Repository Manager, DesignerInformatica Developer, SQL*loader, PL/SQL, SQL, Unix Shell scripting, Control-M, HP QC, IBM RTC