SUMMARY:

ETL (Extract Transformation Load) Informatica / SSIS Development Professional. Experienced in Analysis, Design and Development in Informatica Power Center 9.5.1, 9.6 and 10.01. Also completed development in SSIS (Sql Server Integration Service) 2008, MicroStrategy 9.4.1, Netezza with strong knowledge in Data Warehousing, Analytics and Data Quality. Enthusiastic team player and pragmatic leader.

EXPERIENCE:

• Experienced in Informatica Power Center 9.5.1, 9.6.1 and 10.01
• Experienced in creating SSIS package using features, using export/import wizard and execute the package for data extraction, transformation and load.
• Experienced in migrating data from RDBMS to AWS creating data warehouse using Redshift and AWS Migration hub.
• Closely worked with data modeler to review for the best trasnformation
• Developed a significant data reconciliation mapping framework in Informatica (other ETL tools can be leveraged) that helps in validating the migration process from one database to other and it is part of organization’s Business Intelligence tool set
• Used Designer, Workflow manager to create and run the Workflows and different tasks like worklets, Timer, etc with high reusability
• Connected with different source files like SQLServer 2008 R2, Oracle 12c Database, Flat files, SalesForce.com and extensively used XMLs as source
• Extensively used Netezza warehouse appliance using Aginity Workbench utility for pure data analytics
• Extensively used pmcmd command to start the workflows based on requirements
• Used Autosys to schedule the workflows
• Implemented mapping for SCDs and CDC in Informatica
• Good knowledge in Star and Snow flake schemas and Data modelling
• Basic Domain knowledge in Capital Markets and Banking and Financial Services
• Good knowledge in Microstrategy 9.4.1 and Qlikview 11.1
• Built comprehensive operational dashboards using MicroStrategy
• One stop solution provider for various map tools irrespective of technologies
• Quick learner and flexible enough to adapt to new environments
• Good presentation and communication Skills
• Ability to work as a team player and independently

TECHNICAL SKILLS:

Skills and Knowhows: Informatica, MicroStrategy, Tableau, SalesForce.com, FTP, XML, SQL Developer, SQL plus, Putty, Oracle 12C, Informatica Data Quality center, IBM Infosphere Analyzer, Aginity Work Bench, Autosys, Unix, Unix administrator, AWS, Hadoop Distributed File System Administrator, Ab - Initio 2.1, Cyber Security, Cucumber, Ruby, HTML, XML XSD, JS, IBM DB2.

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk

Core Team Member

Environment: s: Windows 10, Oracle 12g, Express Encounter Pro (.NET), SQL Server 2014, SQL Server Management Studio, Visual Studio, SVN, Tidal, Python

Responsibilities:

• Responsible for data analysis using SQL and Excel for the unit test.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Modified Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Coordinated with the QA, System Analysts and Business for reviewing scenarios and functionalities.
• Participated in daily scrum/Kanban meeting to discuss the status of the application, block and s during the daily standup.
• Responsible to send daily devlopment status to the management.

Confidential

Core Team Member

Environment: Oracle 11G, Informatica 9.5.1 HF3 and 10, Data Transformation Studio, Oracle 12c, Autosys, Netezza Aginity Workbench Utility for Pure data Analytics

Responsibilities:

• Agile model followed for execution with all the scrum ceremonies
• Gathered business requirements for the legacy system
• Designed and implemented a conventional day to day load job to hydrate a DataMart component
• Used Netezza extensively and created NZSQL scripts along with UNIX codes for achieving a better program
• Created DT project to handle XML as a source
• Created Informatica mappings, sessions, workflows using XML files as source and Relational tables as target
• Involved in designing of mapplets, reusable transformations and mappings using parameters and variables
• Created CDC process for the incremental updates
• Custom error handling functions implemented
• Used extensively the parameter files and pmcmd files based on needs
• Used workflow manger, workflow monitor to test the mapping in DEV before migrating to QA and Production
• Created batch scripts to split files into different files by reading the contents of the file and use the same as source
• Used AutoSys to automate the workflows on daily basis
• Used Aginity Workbench utility to connect with Netezza database
• Implemented the key business rules based on the customer’s requirement
• Check the dependencies to run the jobs and load the data as per client requirements
• Checked the logs and output files whether they are created as per business
• Monitored the Informatica job that runs daily
• Involved in RunBook, Shakeout document, operations manual and other documentations materials required for the production release
• Eventually, migrated newly built application data from the data center to Amazon Redshift by using AWS migration hub.
• Using Import feature of AWS Migration hub, import data into to the customized EC2 server instance and monitored the status through Server Migration Service.
• Built the Data warehouse in Redshift that extends the queries in the data lake.

Confidential, McLean, Virginia

Core Team Member

Environment: MicroSoft SQL server 2008 R2, Business Object

Responsibilities:

• Gathered the business requirements by coordinating and communicating with business team
• Analyzed the unstructured data and designed the schemas for extracting the data on the whole and used indirect loading
• Created Informatica mappings, sessions, workflows using XML files as source and Relational tables as target
• Involved in designing of mapplets, reusable transformations and mappings using parameters and variables
• Worked on slowly changing dimensions (SCD) type I and II using lookup, filter, update and expression transformation
• Used normalizer transformation extensively to implement error handling
• Used extensively the parameter files and pmcmd files based on needs
• Used workflow manger, workflow monitor to test the mapping in DEV before migrating to QA and Production
• Used extensively the string functions and variables to handle the business requirements wherever applicable
• Created windows scripts to auto pick the files and moves to other locations
• Created batch scripts to split files into different files by reading the contents of the file and use the same as source
• Use AutoSys to automate the workflows on daily basis
• Implemented the key business rules based on the customer’s requirement
• Check the dependencies to run the jobs and load the data as per client requirements
• Checked the logs and output files whether they are created as per business
• Monitored the Informatica job that runs daily
• Create tickets based on the priorities and work on the tickets.
• Communicate with all the teams to let know the status of the issue and tickets
• Prepared the documents for the mapping design and maintaining issue logs

Confidential, Wilmington, DE

Team Member

Environment: Informatica 8.16, 9.1, SQLServer 2008 R2

Responsibilities:

• Core Team member in developing artifacts for the datawarehouse
• Created Complex Mappings, Sessions and Workflows for the ETL requirements requested by the clients
• Involved in designing of mapplets, reusable transformations and mappings using parameters and variables
• Created task like session, event wait, event raise, command, decision and control task using workflow manager and monitored the jobs in workflow manager
• Connected with different source systems XMLS, SqlServer 2008R2, Peoplesoft, SAP, SalesForce.com
• Used indirect and bulk load for better performance of and easy load of data
• Used Aggregator, Filter, Router, joiner, Expression, Look Up, Union & Update Strategy transformations frequently to satisfy the requirements
• Used Informatica designer to create mappings using transformations like lookup, router, filter, sequence generator, joiner, aggregator, source qualifier and expression transformations to transform the data as per business logic
• Created task like session, event wait, event raise, command, decision and control task using workflow manager and monitored the jobs in workflow manager.
• Used SCDs and CDC to keep track of changes and incremental loading respectively
• Used string and date functions based on the requirements
• Created connections between Informatica to SAP systems to load data into them.
• Create SAP transformation and import the IDoc structure and number of segments.
• Import Idoc basic type, required control records and segments.
• Created and assigned variables as per the mapping requirements.
• Used AutoSys to automate the workflows on daily basis
• Worked in performance tuning by increasing cache, override the SQL
• Monitored the Informatica job that runs daily
• Participated in unit testing, regression and system testing
• Worked on production support issues
• Check the logs for the initial issues for the failures and analyze the issues and resolve them.
• Maintained production checklist of mappings