PROFESSIONAL SUMMARY:

• 7+ years of increasing experience as a Senior Informatica Programmer with a strong, demonstrable background in Financial and Healthcare.
• Proficiency in using Informatica Power Center tool 8x to 9x.
• Hands on experience in handling data from various source systems such as Flat Files, XMLSource, Oracle, MS SQLServer, IBM DB2, Teradata and Excel Files
• Experience involved in Performance Tuning, Error Handling, Production Support and debugging mappings.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Different databases.
• Extensively worked on Monitoring and Scheduling of Jobs using UNIX Shell Script and BTEQ Scripts.
• Expertise on tools like Toad, SQL*Plus and SQL Server Management Studio.
• Involved in Manual and Automated Testing of applications on UNIX and Windows Environment.
• Good exposure to the Software Development Life Cycle (SDLC) and OOAD Techniques.
• Have a clear understanding of Business Intelligence and Data Warehousing Concepts.
• Having experience in Data Warehousing technologies concentrating on the Datastage, Oracle 11g, Teradata V12, AWS Redshift, SQL server Informatica and autosys.
• Strong Technical skills in range of technologies which includes Informatica ETL, Oracle, Sybase, DB2, COBOL, UNIX, PL/SQLand Teradata.
• Expertise in developing reusable transformations, Mapplets, Workflows, worklets and sessions/tasks in Power Center Tool.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Flexibility to change/leverage with any new Technology
• Experience working with agile methodologies.
• Strong Data warehousing concepts, Dimensional Star Schema
• Experience in providing estimates for initiatives based on impact analysis
• Experience working with agile methodologies.
• Experience in converting business requirements into technical requirements.
• Effectively managing the entire development lifecycle, both independently and collaboratively, by maintaining contact and strong relationships with the leaders in other groups.
• Collaborating with IT and business to define a plan of execution for database based projects ranging in scope from a month to a year.
• Strong written and verbal communication skills at all levels to effectively drive buy in from Senior Executives in both IT and Business as well as maintaining the focus of the development team.

TECHNICAL SKILLS:

ETL: Informatica 8x,9x and 10x

Operating systems: Windows, Unix

Programming Languages: PL/SQL,COBOL,Perl,C,C++

Database Systems: Oracle, DB2, Sybase, Teradata

Scripting Languages: Shell scripting

Tools: RapidSQL,Autosys, IBM Clearcase

Amazon Web Services (AWS): Redshift,DynamoDB, S3, EC2, EMR, Data Pipeline

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

Sr ETL Informatica/IDQ Developer

Responsibilities:

Responsibilities:

• Working with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
• Involved in creating Logical and Physical design of data models using Visio.
• Actively involved in requirements gathering and complete life cycle of the project.
• Involved in Migration of Informatica 9.5 to Informatica 10.1
• Extensively worked on Informatica client tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplets Designer, Mapping Designer, Workflow Designer, Worklet Designer and Task Developer.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, XML files etc. into the Staging table and then to the target database.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Performing data analysis and gathered columns metadata of source systems for understanding requirement feasibility analysis, Data Quality (IDQ) MDM Hub solutions.
• Developed new and maintaining existing Informatica mappings and workflows based on specifications.
• Created Mapplets, reusable transformations, Worklets and used them in different mappings, workflows.
• Used Source qualifier, Expression, Aggregator, Lookup, Router, Normalizer, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components
• Performed trunk & Load process by using stored procedure transformation and load control table to stage the data.
• Worked on Slowly Changing Dimensions i.e. Type1 & Type2.
• Designed and Implemented the ETL code for Address verification, Identity checking by working with IDQ.
• Performed incremental aggregation to load incremental data into aggregate tables.
• Developed PL/SQL scripts, stored procedures, Indexes, Constraints, partitions and triggers in Oracle.
• Worked on production issues like bug fixing, bottlenecks, data validation and report errors.
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Created pass through session partitions to improve performance of reading source data.
• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Scheduled the entire process in Autosys.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them.
• Involved in designing and developing the reporting requirements by using Business Object Xi3.1, Business Objects Report Designer.

Environment: Informatica Power Center 10.1/9.5, Erwin, MS Visio, Oracle 11g/10g, SQL, PL/SQL, TOAD, MY SQL, SQL Server 2008, IDQ, Mainframe, XML, Business Objects Xi 3.1, Autosys, UNIX Shell Scripting, MKS Integrity

Confidential

Sr.ETL/Informatica Developer

Responsibilities:

• Worked heavily with Business Analyst to understand the business and to design the HLD'S and LLD'S.
• Designed the metadata tables and created mappings to populate the same. These tables were used to generate the parameter files.
• Having exposure on Informatica Cloud Services.
• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the DataMart with only required information.
• Created reusable transformations to clean the data, which were used in several mappings.
• Strong experience with Informatica Data Quality IDQ 9.6, Informatica Analyst andInformatica Power Center ETL 9X, 10X ETL tools.
• Developed and tested stored procedures, functions and packages in PL/SQL
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Worked on cutting edge technologies SQL Server, SSIS, SSAS, SSRS, AWS RedShift, EMR, NoSQL, HDFS, Hive, REST API, VBA/EXCEL and Python.
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Planned, created and executed packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Designed and implemented stored procedures and triggers for automating tasks in SQL Server 2008/ Oracle 10g.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Designed Mappings using B2B Data Transformation Studio.
• Experience in Systems Integration using Informatica B2B Data Exchange.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Used Oracle 9i features such as merge for various transformations.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Used Informatica Power Center for extracting, transforming and loading of data from SAAS data warehouse into Epiphany staging database.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.

Confidential, Phoenix

Informatica/Oracle Developer

Responsibilities:

• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Developed strategies for Incremental data extractions as well data migration to load into the Teradata. And also assisted in designing Logical/Physical Data Models.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the Power Center, Power exchange.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Created SSIS Packages to migrate slowly changing dimensions. Expert knowledge SQL Queries, Triggers, PL/SQL Procedures, Packages to apply and maintain the Business Rules.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, Created testing metrics using MS-Excel
• Used Informatica Power center workflow manager to design sessions, assignment, e-mail and command to execute mappings.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts, Wrote PL/SQL scripts for dropping, rebuilding indexes.
• Performed Configuration Management to Migrate Informatica mappings/sessions/workflows from Development to Test to production environment.
• Create & maintained cron jobs using Shell Scripts.
• Part of performance tuning team, tuned PL/SQL code and SQL queries using Execution plan and TOAD.

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Involved in the maintenance and enhancement of the application.
• Used the technical document to design the database tables.
• Involved in designing the database using ERWIN.
• Writing SQL*Loader Scripts to load huge data into tables.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Communicate issues and progress to project manager.
• Developed PL/SQL coding standards.

Confidential

Oracle Developer

Responsibilities:

• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used DDL and DML to create and manipulate data
• Developed Control scripts and loaded existing data using SQL * Loader.
• Developed stored procedure using PL/SQL to update payment info into Bills.
• Developed Database Triggers to enforce security.
• Generate reports, day-to-day administration jobs.
• Developed Forms /Reports using Forms 4.5i and Reports 4.5i and solved Numerous Problems in Reports.