EXPERIENCE SUMMARY:

• 7+ Years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing
• Experience in Requirement Gathering and Requirement Analysis
• Expert in Futuristic ETL Design considering Standardization, Reusability, and Scope to improve
• Strong experience in installation, configuration and administration of Informatica Power Center and Power Mart Client, Server and designing/developing complex mappings, from varied transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Normalizer, Stored procedure and more
• Proficient in using Workflow Manager Tools such as Task Developer, Workflow Designer and Worklet Designer. Experience in performance tuning of sources, mappings, targets and sessions
• Experience in working with various versions of Informatica Powercenter Client tools
• Experience in creating mappings to implement Slowing Changing Dimension
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks
• Experience in creating pre - session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs
• Experience in integration of various data sources like Oracle, SQL Server, DB2, Flat files
• Strong experience in complex PL/SQL packages, triggers, views, materialized views
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping
• Experience on Scripting and Programming using Unix Shell, HTML, DHTML, PL/SQL Stored Procedures, Triggers and Functions
• Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.
• Experience includes thorough domain knowledge of Business Financial system, Banking, healthcare information technology, Insurance & Reinsure, Pharmacy claims systems, Telecom Industry
• Proficient team player with the ability to communicate effectively at all levels of the design through production process
• Experience creating Webi reports using SAP Business Object
• Experience using Team Foundation Server(TFS) for Task and Defects
• Experience in agile methodology and well-versed with sprints
• Experience in scheduling tools like Autosys, Control M
• Experience in Banking, Insurance and Clinical Trial Domain

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6.1 / 9.5.1

Reporting Tool: SAP Business Object

Data Modeling Tools: Erwin

SDLC methodology: Waterfall and Agile

Operating System: UNIX, Linux, and MS Windows NT/2000/XP

Database: Oracle 10g/11g/12c, MS SQL Server, DB2

Document Management: SharePoint, BOX

Languages: SQL, PL/SQL, Shell Scripting

SQL Editor /Tools: SQL Navigator, Oracle SQL Developer, WinSQL, Oracle Toad, SQL Editor, PuTTy

Scheduling Tools: Distributed Control M job scheduler, Autosys, Auto Flow

Incident Management Tool: JIRA, TFS, Cherwell

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Senior ETL Developer

Responsibilities:

• Estimate the impact of incidents and effort needed to fix the issues
• Working with Architects on issues, possible solutions and design the solution approach for various ETL jobs.
• Review changes done by other team members
• Team spanning across globe, I was also involded in presenting the changes done by my team in change approval board (CAB) meetings
• Providing bi-weekly status to downsteam teams on the active high and medium priority issues worked by my team
• Acknowledge the issues and fix the issues in Cherwell and JIRA
• Develop ETL mappings and unit test the code
• Migrating changed codes to production and retesting the data again

Environment: Linux, Informatica PowerCenter 9.6.1, Sybase, DB2, Autosys, DBeaver, RapidSQL, Cherwell.

Confidential, Madison, WI

Senior ETL Developer

Responsibilities:

• Helping in estimate the effort
• Working with Architects on solution design, develop ETL mappings and unit test the code
• Involved in importing source/target tables from the customer mount point and respective databases and created reusable transformations, mapplets and mappings using designer
• We use different types of logics like Update logic, Replace Logic, Smart Logic, Cumulative data calculations
• Implementing the new Customer flow according to the requirements that will meet Customer expectations
• Create metadata entries and Autosys jobs
• Migrate the code to INT and test the code
• Acknowledge the issues and fix the issues in Team Foundation Server (TFS)
• Migrate the code and load test data for QA and UAT
• Performance test the code and make the documentations for production release
• Migrating changed codes to production and retesting the data again

Environment: Linux, Informatica PowerCenter 9.6.1, Oracle, PostgreSQL, Control M, WINSQL, SQL Developer, SQLNavigator, and pgAdmin III service

Confidential, NJ

BI/ETL Developer

Responsibilities:

• Worked with the Business Analysts and PME system architects to understand the requirements and design the Data Integration process to load the data to PME
• Worked with new clients to understand their data requirement to serve them better
• Worked with vendor teams from TCS and Infosys as a vendor manager
• Designed technical layout considering Standardization, Reusability, and Scope to improve, if needed
• Train and mentor the junior team members and vendors to make them understand the PME process flow/data model
• Developed complex mappings to extract source data from heterogeneous databases Sybase, Mainframe DB2, Oracle, MQ queues, XML and flat files, applied proper transformation rules and loaded in to Data Warehouse
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Worked closely with change management team and handled periodic releases
• Ensured timelines are met for integrating new clients smoothly
• Developed K-shell and Perl scripts to run from Informatica pre-session, post session commands. Set up on Success and on Failure emails to send reports to the team
• Developing Mapping/Mapplet/Workflows involving various ETL processes using Informatica
• Writing Unix scripts to process the source files, create parameter files, call workflows and send extract files to clients
• Conducting and Participating Peer code reviews

Environment: : Linux, Informatica PowerCenter 8.6.1, DB2, PL/SQL, Unix Shell scripting, Autoflow, WINSQL, SQLNavigator, Erwin Data Modeling tool.

Confidential, NJ

ETL Developer

Responsibilities:

• Extracted the source data from legacy systems and moving them into the staging area
• Created Intermediate views
• Created mappings and mapplets using Informatica
• Designed ETL mappings using Informatica
• Prepared the ETL specifications for the business logic
• Documented each process
• Prepared unit test plan documents
• Worked on Informatica - Source Analyzer, Data warehousing Designer, Mapping Designer, Mapplet, and Transformations
• Created SAS datasets using the metadata
• Tested and migrated the scripts to the UAT environments by coordinating with the EDS team

Environment: Oracle Clinical, Linux, Informatica PowerCenter 9.5.1, Unix Shell scripting, WINSQL