- Informatica 9.6/9.5/9.1/8.6/8.1/7.1, Ab Initio 1.14 GDE 2.14.1 Co-Operating system, Teradata V2R5, Oracle 9i/10g, MS SQL Server, Control-M, Autosys, Erwin, Business Objects BOXI-R3.1 , Oracle Warehouse Builder OWB
- Informatica Power Center ,Informatica Power Exchange, Informatica-B2B Data Transformation Ab Initio Control-M, Erwin, Rational ClearCase, Mercury Test Director, BO, Remedy, Autosys, Cognos
- Domain Experience
- Sales and Marketing, Services, Manufacturing, Card Payment, Finance, Healthcare, Customer experience, Human Resources, Transportation
- Oracle 9i/10g/11gR2, SQL, PL/SQL, Microsoft SQL Server, Teradata V2R5, DB2
|
| Experience |
| Confidential ETL Lead/Sr.Developer - Developed the ETL program to extract the data for Fannie Mae SAM Security accounting management project to generate the report to monitor the Fannie security system.
- Analyzed and document business requirements.
- Created high level design, technical design documents and mapping documents based on business requirements.
- Configured, designed and developed of ETL for SAM Data mart.
- Optimized the complex ETL process using Performance Tuning Methods.
- Created program to implement Change Data Capture CDC using Informatica to perform inserts, updates, and deletes operations.
- Done root cause analysis and fixed the critical Sev 1/2 Production issue logged in Remedy within given SLA.
- Monitored and executed the production jobs whenever required.
- Performed unit, system and integration testing to validate source and target data and performed Internal Quality Auditing of the ETL code before delivery.
- Created Informatica tasks and workflows to execute ETL processes.
- Written complex SQL Query as per business requirement to fetch the data from relational tables
- Done optimization on complex SQL query to improve the performance.
- Created Slowly Changing Dimension SCD type1, type2, Slowly Growing Targets, and Simple Pass Through Informatica mappings to meet business requirement.
- Worked on XML source/target and used XML Source Qualifier, XML Parser and XML Generator transformation.
- Performed Unit testing, Integration testing and User Acceptance testing for ETL/SQL/Unix script code.
- Executed Autosys command/box to run the Informatica workflows.
- Developed Unix shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process Automation.
Confidential Sr.Developer/Architect - Developed the ETL program to extract the data from various source systems and load it into Enterprise data ware house for multiple projects in Amtrak which Includes Multiride , E-Ticketing, Labor , Meal check/Meal Period and State Partner to generate the revenue reports.
- Documented and designed technical architectures, ETL best practice and solutions as per business requirement.
- Performed Informatica administration tasks including user creation, connections, folders, migrations 9.1 to 9.5 , installation, upgrades and troubleshooting.
- Done deployment of Informatica code using export/import and deployment group methods and govern standards and best practices
- Setup and configure Informatica domains, services repository, Integration .
- Managed and assigned tasks to a 5-members team.
- Daily communication with SME/Business Analysts via mail, chat, teleconferences.
- Contributed to logical and physical data modeling for the new enterprise data warehouse EDW
- Created high level design, technical design documents and mapping documents based on business requirements.
- Contributed to logical and physical data modeling for the new enterprise data warehouse EDW
- Configured, designed and developed of ETL and Enterprise Data Warehouse applications.
- Optimized the complex ETL process using Performance Tuning Methods.
- Created program to implement Change Data Capture CDC using Informatica to perform inserts, updates, and deletes operations.
- Done root cause analysis and fixed the critical Sev 1/2 Production issue logged in Remedy within given SLA.
- Monitored and executed the production jobs whenever required.
- Performed unit, system and integration testing to validate source and target data and performed Internal Quality Auditing of the ETL code before delivery.
- Created Informatica tasks and workflows to execute ETL processes.
- Written complex SQL Query as per business requirement to fetch the data from relational tables
- Done optimization on complex SQL query to improve the performance.
- Created Slowly Changing Dimension SCD type1, type2, Slowly Growing Targets, and Simple Pass Through Informatica mappings to meet business requirement.
- Worked on XML source/target and used XML Source Qualifier, XML Parser and XML Generator transformation.
- Used unstructured transformation to read the data from Informatica-B2B .
- Performed Unit testing, Integration testing and User Acceptance testing for ETL/SQL/Unix script code.
- Developed Unix shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process Automation.
Confidential |
| Senior ETL Developer/Lead |
- Developed ETL procedures to convert the Human Resources database HRDB from DB2/mainframe to Oracle/Unix platform and to facilitate integration with Health and Human Services HRDB.
- Requirements Analysis - Identify sources of data and document business rules
- Convert existing processing of HRDB data in to Informatica mappings and move all HRDB tables into Landing/Staging area.
- Perform one-time data migration to move all existing HRDB data to Enterprise data ware house EDW
- Perform data validation and eliminate reliance on DB2/mainframe as a source.
- Created complex SQL queries ,joins as per business requirement to fetch the data from Oracle Tables
- Build Informatica ETL processes to load data through the Staging layer in to EDW
- Support down-stream users and migrate the down-stream users from DB2 to Oracle
- Created various Transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy to implement the business logic.
- Creating Informatica tasks/Workflows to perform the ETL execution.
- Created store procedure, function, Cursor and trigger using oracle PL/SQL.
- Performing unit/integrated testing of ETL process as per business requirements.
- Involved in designing of star schema and snowflake schema for EDW.
- Developed Unix shell script as per business needs.
|
| Confidential |
| ETL Lead, MAS BI |
- Managed an ETL Development project for the Mid Atlantic State MAS region that transformed member data from various source systems and loaded the data to a target system from which operational and analytical reports were sent to Kaiser's senior executive for business analysis.
- Gathered requirements with business analyst in group sessions with on-site and offshore management.
- Created high level design, technical design documents and mapping documents based on business requirements.
- Created Ab Initio graphs to capture the Mid Atlantic State MAS region member data from various source systems and loaded the data to a target system .
- Used various Ab Initio components like Lookup, Join, Reformat, Filter by expression, Rollup, Scan, Redefine format, Merge, Gather, Replicate, Sort etc.
- Performed unit testing for Ab Initio graphs that were updated based on change requests and business requirements
- Optimized complex ETL processes using Performance Tuning Methods.
- Involved in unit testing, integrated testing and regression testing.
- Created Informatica data validation mapping to validate the source system data based on business need.
- Developed Complex Informatica mappings/workflows to perform ETL process from source to target systems.
- Created and executed reports using BOXI R3.
- Developed Unix shell scripts to schedule and execute ETL jobs using Crontab.
- Worked on Informatica MDM, B2B and IDQ.
- Worked with XML source and target as per business requirement.
- Developed complex SQL to fetch the Source/Target data for analysis, testing and reporting.
- Performed Informatica administration tasks including user creation, connections, folders, migrations 8.6 to 9.1 , installation, upgrades and troubleshooting.
- Setup and configure Informatica domains, services repository, Integration .
- Managed resources and identified and selected new project personnel.
- Planned, managed and executed the project.
- Managed and assigned tasks to a 7-member team.
|
| Confidential |
| ETL Lead/Architect |
- Developed ETL procedures for an organization that delivers subscriber-centered, provider supportive services that optimize expenditures and improve health care for Medicare agencies, state and local governments, health plans, employers, and labor trust groups.
- Reviewed and contributed to business requirement documents with business analysts and with on-site and offshore management teams.
- Created detailed ETL design documents and mapping documents based on business requirements documents
- Created various transformations using Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy.
- Estimated costs and monitored the quality of products and services.
- Managed a team and assigned and supervised work from functional and technical perspectives.
|
| Confidential |
| ETL Lead developer/Architect, |
- Implemented the logic and developed the architecture for the Visa Clearing Settlement C S application
- Developed the Informatica mappings and workflows for C S based on the business requirements document.
- Contributed to logical and physical design of the C S architecture.
- Coordinated with business analyst to discuss the logic and ensure that the business requirements were implemented.
|
| ETL Lead, Visa Distributing Processing Services |
- Designed ETL procedures for VDPS, the application that authorizes credit card payment transactions.
- Created Ab Initio graphs based on business requirement documents using various components like Lookup, Join, Reformat, Filter by Expression, Rollup and Scan.
- Coordinated with business analysts during requirements gathering for downstream data feed management system and to develop code for enhancement requests.
- Developed code to extract data from journal files coming from the VDPS switch.
- Performed unit testing for Ab Initio graphs that were updated based on change requests and business requirements.
- Fix bugs and defects identified during system integration and regression testing.
- Provided second level production support for resolving high severity severity 1 issues.
|
| Confidential |
| Senior ETL Developer |
- Developed ETL procedures to migrate data from an existing data warehouse to an integrated enterprise level data warehouse.
- Created and executed mapping using Slowly Changing Dimensions Type 2, Slowly Growing Target, and Simple Pass Through.
- Prepared technical designs for Informatica mappings.
- Developed mapping for fact loading from various dimension tables.
- Contributed to logical and physical data modeling for the new data warehouse.
- Created BTEQ, MLOAD and FLOAD scripts for loading and processing input data.
- Created and executed macros using Teradata SQL Query Assistant Queryman .
|
| Confidential |
| Senior ETL Developer, Center for Excellence |
- Maintained Oracle Data marts for Dell Premier Customers and resolved issues that impacted the Finance, Service, Customer Experience, Manufacturing and Telecom domains.
- Designed and developed mappings based on customer requirements specifications.
- Conducted root cause analysis to fix issues and eliminate bugs that were identified by business users.
- Contributed to Table Space Reorganization to maintain Oracle Data marts.
|
| ETL Developer |
- Supported a system that measures issues that occur within 60 days of shipping that are caused by incomplete, incorrect, and damaged orders.
- Developed Teradata macros to automate SQL procedures.
- Created Ab Initio graphs to capture the cost impact of shipping and order fulfillment issues versus customer experience.
- Used various components like Join, Filter by Expression, Rollup, Lookup, and Sort.
|
| Confidential |
| ETL Developer |
- Designed a Data Warehouse using Informatica to improve business decision-making for a leading manufacturer of electronic equipment.
- Coordinated with executives, senior managers, and business analysts to design ETL processes to consolidate information from file sources and an Oracle DB into a target Oracle data warehouse.
- Created various transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy.
|
Privacy Policy
