SUMMARY:

• Experience in design, development, test, and maintenance of database applications using tools and technologies such as Informatica PowerCenter, Developer, B2B Data Exchange, B2B Managed File Transfer, IDQ, SQL Server, Oracle PL/SQL
• Experience in and data migration and consolidation of CIS mainframe legacy system to Oracle CC&B
• Complete working knowledge of V - model in Oracle CC&B
• Integrated various data sources like Excel, EDI, XML, flat files and worked on multiple relational databases like Oracle and SQL Server
• Developed ETL maps for supporting extraction, transformation, and loading of data using Informatica PowerCenter and Informatica Developer
• Developed complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected/Connected Lookups, Stored procedures, Aggregators, Normalizer, Web service consumer, HTTP, Unstructured Data Transformation, Java Transformation, XML parser, XML generator, and SQL transformations in Informatica PowerCenter
• Used Parsers, Serializers, and Mappers based on the requirement using Informatica Developer
• Implemented Data Masking to mask sensitive data
• Implemented Type 1 and Type 2 slowly changing dimensions
• Developed and configured Sessions, Worklets, Workflows in Workflow Manager
• Built XML Schema Definitions (XSD) using Informatica Developer
• Worked on data profiling, cleansing, standardization, parsing, verification, matching and data quality exception monitoring and handling using IDQ Developer
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in UNIX environment
• Extensively utilized parameters and variables in Informatica
• Worked on Json data to create tickets on Jira automatically upon encountering errors
• Expertise in Data warehousing concepts like OLTP/OLAP systems
• Configured Database and ODBC connections to different sources and targets on the server and used absolute FTP connections to read files from various FTP sources
• Data modeling experience using DDL, Star Schema, Snowflake Schema on fact and dimension tables
• Experience in debugging mappings- Identified bugs in existing mappings by analyzing the data flow and evaluating transformations
• Identified the bottlenecks and performed performance tuning of Informatica maps and SQL queries
• Prepared Technical Design Documents and Test Documents
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions
• Knowledge on reporting tools like Oracle Business Intelligence Enterprise Edition (OBIEE), Tableau
• Trained and mentored teammates on Informatica PowerCenter
• Worked on both Waterfall and Agile methodologies
• Performed System Analysis and QA testing and involved in Production Support
• Worked on Json data to GET and POST messages using HTTP and Web Service Consumer
• Tested web services using SoapUI, Swagger, and Postman

TECHNICAL SKILLS:

Programming Languages: T-SQL, Oracle PL/SQL, C, C++, Java, HTML, CSS, Python

Databases: Oracle 12c/11g/10g/9i, MS SQL Server 2008/2012, Toad, Embarcadero Rapid, SQL Developer, SQL Plus

ETL/ Data migration tools: Informatica PowerCenter 10.2, 10.1.1, 9.6.1, 9.5.1, 9.1.0, 8.6.1, Informatica Developer, Informatica DataTransformation, Informatica B2B DataExchange, Informatica B2B Managed File Transfer, SSIS

Data Modeling: Power Designer, Erwin, MS Visio

BI Tools: Oracle Business Intelligence Enterprise Edition- OBIEE 10g

Scheduling Tools: Control-M, Autosys

Operating Systems: Windows 97, 2000, 2005, XP, 7, 8, 10, UNIX, Linux

Tools: Putty, WinSCP, HP Quality Center, Jira, Confluence, SoapUI, Swagger, Postman, AWS, MS Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, Alabama

Lead ETL Developer

Responsibilities:

• Created and maintained technical specification documents
• Developed Informatica mappings to ingest .txt, .csv, and VSAM files and load into Oracle Database
• Developed Informatica mappings to read data from staging and load it into the Data mart depending upon the business requirements
• Developed User Defined Functions and mapplets to accommodate reusability
• Identified bottlenecks and improved performance of workflows using pass through and key range partitioning at session level
• Performed Migrations in Informatica using Deployment groups
• Performed partitioning and local indexes at Database level for transaction tables to maintain and retrieve data effectively
• Integrated automation for adding and truncating partitions on database, disable and rebuild indexes, and statistics collection maintenance packages in pre and post SQL at session level in Informatica
• Worked on data profiling and cleansing using IDQ Developer
• Performed first level code reviews for the team
• Built a process to log the success and failures of workflows
• Created and modified dependencies in Control-M
• Created tickets in Remedy and CAT for Informatica, Database, and Control-M for weekly deployments
• Used Microstrategy for logging errors in production which is used for reporting purposes
• Efficiently managed a team of developers and testers and delivered the data on time
• Constantly interacted with Line of Business for gathering the requirements and building Informatica mappings and other business related processes
• Created and monitored tasks on Jira
• Hosted and lead Scrum meetings and followed up with respective business owners to effectively deliver the data

Environment: Informatica PowerCenter 9.6.1/10.2, Informatica Data Quality (IDQ) 10.2, Toad 12.8, WinScp, BMC Remedy Action Request System, CAT Ticketing tool, Control-M 6.4, Jira, Windows 10

Confidential, Charlotte, North Carolina

Lead Data Integration Engineer

Responsibilities:

• Designed the process to capture files that were submitted through Email, FTP, or Web portal
• Developed Parsers, Serializers, and Mappers in Developer to handle different types of input data
• Developed mapplets in Informatica Developer to process the source files
• Exported Developer mapplets and integrated them into Informatica PowerCenter mappings
• Extensively used HTTP transformation to call the webservice
• Created Jira tickets for errors through PowerCenter using Http Transformation
• Built XSDs and used XML parser to parse XML data received from Developer mapper
• Sent acknowledgements to Web Services using HTTP transformation
• Created unique keys using MD5 and SQL transformation
• Used indirect file upload procedure to load data from multiple flat files
• Extensively used parameters and variables for reusability and easy maintenance
• Used Postman, Swagger, and SoapUI to test out web services
• Created Technical Design Documents for processes and mappings
• Written Windows batch scripts to archive and rename the files

Environment: Informatica PowerCenter 10.1.1 Hotfix 1, Informatica Developer 10.1.1, Informatica B2B Data Exchange, Informatica B2B Managed File Transfer, SoapUI 5.4.0, Swagger, Postman, SQL Server 2014, Jira, Confluence, Microsoft Visio, MS Visual Studio 2017

Confidential, Atlanta, Georgia

Sr. Informatica/ Database Developer

Responsibilities:

• Designed and built Informatica maps for conversion of legacy mainframe Customer Information System (CIS) data to Oracle Customer Care and Billing (Oracle CC&B)
• Extensively used Expression, Normalizer, Lookup, Sorter, Union, Joiner, Filter, Router, XML parser, XML generator, Java, and SQL transformations in Informatica PowerCenter
• Interacted with project managers to gather business requirements
• Prepared Technical Design Documents and Test Documents
• Developed complex SQL queries to pull data from different relational databases like SQL Server, Oracle based on the requirements
• Built Stored Procedures, Cursors, Functions in Oracle PL/SQL
• Developed UNIX scripts to run Oracle CC&B toolkit jobs
• Used Windows batch scripts to rename, move, generate random numbers, and add system time as file extension
• Identified bottlenecks in Informatica and SQL queries and optimized them by applying appropriate performance tuning techniques
• Raised defects in HP Quality Center and fixed defects by applying data repairs
• Documented all the workflows using Microsoft Visio
• Implemented version control and performed migrations between environments
• Designed workflows, created worklets, used decision, event wait, and assignment tasks
• Performed unit testing on ETL maps for several teams
• Performance tuned Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
• Implemented partitioning for better performance of Informatica maps
• Validated converted data in Oracle CC&B application
• Strong knowledge of V- model in Oracle CC&B
• Involved in production support and onshore- offshore model
• Trained new team members on Informatica PowerCenter

Environment: Informatica PowerCenter 9.1.0 Hotfix 4, SQL Server 2012/2014, Oracle, Oracle CC&B, Putty, WinSCP, HP Quality Center, Microsoft Visio, MS Visual Studio 2012

Confidential, Phoenix, Arizona

Informatica Developer/Integrator

Responsibilities:

• Worked on Embarcadero Rapid SQL 8.1.0 to write and optimize SQL queries
• Performed performance tuning on SQL queries using Query Optimizer, Execution plans and Indexes
• Extracted data from multiple data sources, such as relational tables, XML files, .csv files, flat files, and wsdl files
• Extensively worked on XML data sources and used Web service consumer transformation to process OLTP data in Informatica PowerCenter
• Built Stored Procedures, Functions, and Packages in Oracle PL/SQL
• Worked on migration of OLTP system to data marts
• Working knowledge of OBIEE

Environment: Informatica PowerCenter 9.5.0, Embarcadero Rapid, TOAD, OBIEE 10g, Oracle, Autosys, Putty, WinSCP

Confidential, Houston, Texas

Graduate Teaching Assistant

Responsibilities:

• Teaching Assistant for Image Processing, Information Systems Theory and Practice and, Modern System Analysis and Design
• Assisted in designing and evaluating the assignments and conducted lectures
• Assisted graduate and undergraduate students in better understanding the concepts taught in class

Confidential

PL/SQL Developer/ Analyst

Responsibilities:

• Worked with large sets of data and analyzed the problems
• Created business reports and provided solutions to the clients
• Involved in creating Logical Data Models
• Developed SQL code to extract data from several data sources
• Built and maintained SSIS jobs
• Created stored procedures, cursors and functions
• Created reports to analyze data

Environment: MS SQL Server 2008/2010, SQL Developer, SSIS 2008, SQL Loader, Oracle PL/SQL, PowerDesigner, Windows XP

Confidential

Jr. SQL Developer/ Analyst

Responsibilities:

• Developed an application to gauge the performance of the employees
• Interacted with business users to gather the requirements
• Used VB.NET for developing user interface
• Established ODBC connections
• Designed and defined database structure
• Created Database objects like Tables, Views, Primary Keys, Indexes, Constraints, Grants, Synonyms, and Sequences
• Identified relations between objects using ER diagrams
• Assisted in loading data into tables
• Created Technical Design Documents for the application
• Performed Unit testing on the application
• Created separate modules for users and managers

Environment: VB.NET, Microsoft Access, Oracle 9i, Microsoft Visio, Microsoft Excel, SQL Plus, SQL Developer

Confidential

Marketing Lead

Responsibilities:

• Supervised and coordinated marketing campaigns
• Introduced subscription service to the users and sold 3000 copies in the first month