SUMMARY

• 7 years of experience in design, analysis, development, documentation, coding and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL, SSIS, Informatica 9.x/8.x/7.x
• Experienced in all phases of the Systems Development Lifecycle - Analysis, Design and Modeling, System Implementation, System Testing, Acceptance and Maintenance
• Involved in the migration from Oracle to Teradata Database using Informatica power center
• Experienced in performance tuning of mappings, sessions and workflows including partitioning using Informatica Power Center
• Working experience on Informatica installation & configuration, up gradation and hot fixes patches and maintaining Informatica software Power Center 10.x in support of business processing requirements.
• Experienced in Profile Analysis Standardize Clean Integrate Score Carding Marge Match Reference Data from various source systems using Informatica Data Quality IDQ Toolkits.
• Cleansing and processing data from stage to data marts using Informatica transformations.
• Performed all Informatica administration functions such as user access accounts, roles, privileges and LDAP configuration.
• Experience in Performance Tuning and Query Optimization.
• Monitored ETL workflows and logging, providing job reports and status as required.
• Performed ETL failure recovery when required
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball Methodology.
• Experience in BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files
• Involved in the migration from Oracle to Teradata Database using Informatica power center
• Experience in Database Development, Data Warehousing, Design and Technical Management, Involved in functional and technical Systems Analysis & Design, Systems architectural design, Presentation, process data flow design system impact analysis, Gap analysis and documentation
• Understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, HTML, Java, CSS

Data Mining / Reporting Tools: Informatica Client 10.2.0, Informatica Cloud, SSIS, SSAS, SSRS, OBIEE, MS Excel, SAS, R, Tableau, Informatica MDM and Informatica IDQ

Methodologies: Agile, UML, SDLC, Waterfall

Scheduler: Control-M, Autosys, Tivoli

Modeling Technique: Predictive Modeling and Linear Regression

Tools: Salesforce, Bugzilla, HP ALM, Quality Center 9.2, JIRA 4.1/4.0

Databases: MS SQL Server (2012/2008/2005/2000 ), Oracle 10g, 11g, Teradata 14

Process/Model Tools: MSOffice 365, MS Project, MS Visio, MSWord, MS Excel, MS PowerPoint, Cognos, Jasper Reports, Toad for Oracle, Oracle SQL Developer, SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Confidential - Detroit, MI

Informatica Developer

Responsibilities:

• Perform data warehouse designing and testing, including data design, database architecture design, metadata creation, and repository creation to set up the initial data loading concepts.
• Create database tables, views, functions and triggers to store data both in source and target in SQL SERVER and ORACLE 11G.
• Design and develop ETL workflows and mappings using INFORMATICA CLIENT 10.2.0 and INFORMATICA CLOUD.
• Create UNIX scripts move data from target to destined locations and to automate the workflow process.
• Set up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using TIVOLI or IBM WORKLOAD SCHEDULER.
• Write SQL QUERIES to set up the business rules in the databases and schemas. Then to handle data before the workflows begin.
• Use INFORMATICA CLOUD REAL-TIME for connectivity and integrating with salesforce cloud applications.
• Perform ORACLE DATABASE programming using Partitioning, Materialized View and OLAP.
• Implement healthcare data warehousing concepts right from the beginning of the data life cycle.
• Design and develop ETL mappings, mapplets, workflows, worklets and scheduling them for the data to flow through all the business modules continuously.
• Used ORACLE SQL DEVELOPER and SQL Server Management Studio for basic querying and developing filter queries which can be used in ETL mappings.

Environment: Informatica Client 10.2.0, IICS, Salesforce.com, Oracle 11g, Toad for Oracle, SQL Server 2017, SQL Server Management Studio, Unix, WinSCP, FTP, SQL, Force.com, Workbench, Data Loader.

Confidential - Pittsburgh, PA

Informatica Cloud Developer/Salesforce

Responsibilities:

• Design, Development, Testing and Implementation of ETL processes using Informatica Cloud.
• Developed and handled 3 different integrations from SQL Server to Salesforce Business along with production support.
• Developed complex queries to handle data efficiency throughout the mapping flow.
• Engage with customer to understand their use case requirements and propose the development strategy.
• Collaborated with cross-functional application teams to come up with design options in the Integration area.
• Designing of Salesforce data model creating custom objects, defining relationships as per application requirements.
• Worked in Salesforce-Informatica Integration. Experience in Sales Force CRM Configuration, Customization and Testing of applications. Experience using Sales force Administration (SFA), Custom Objects, Custom Tabs, custom fields, role-based Page Layouts, Custom Reports, and Report Folders.
• Strong Knowledge of SFDC standard Objects and familiarity with designing Custom Objects and Force.com platform and integrating it with Informatica process.

Environment: Informatica Cloud, Salesforce.com, SQL Server 2017, Linux, WinSCP, FTP, SQL, Force.com, Workbench, Data Loader, SOQL, MS Access.

Confidential - Springfield, MA

Informatica Developer

Responsibilities:

• Interacted with business users and team leads for better understanding of business specifications and requirements, Identifying data sources and development strategies.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Enforced data compliance by managing the entire lifecycle of data, from end to end using ILM.
• Responsible to monitor and keep the health of Informatica services.
• Worked with data analyst to figure out the business logic that needs to be implemented in the warehouse day to day load.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure and Sequence generator, Joiner, Union and Normalize.
• Worked on Teradata and its utilities - tpump, fastload through Informatica. Also created complex Teradata Macros
• Optimized and implemented the complex business rules by creating re-usable transformations.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Developed multiple ETL processes to synchronize data between Legacy and New systems, moving in both directions (Old to New and New to Old).
• Extensively used PowerExchange for Mainframe to read data from mainframe files and load into Oracle tables.
• Performed Data Masking and Data Subsetting using ILM - TDM.
• Worked on Error handling and performance tuning in Teradata queries and utilities.
• Transferred large volumes of data using Teradata FastLoad, MultiLoad, and T-Pump.
• Developed Teradata BTEQ scripts to implement the business logic and work on exporting data using Teradata FastExport.

Environment: Informatica Power Center 9.5.1/9.6.1 , TDM, FLATFILES (Fixed width and Delimited), TOAD, Oracle 11g, UNIX, WinSCP, PowerExchange for mainframes, SQL, PL/SQL, MS Access, Teradata 14.

Confidential

ETL Data Developer

Responsibilities:

• Created UNIX Shell Scripting for automation of ETL process.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, lookup, Derived Column task and Script Task in SSIS Designer.
• Used Jenkins to automate packaging and deployment of various ETL, Unix components.
• Expertise in Salesforce-Informatica Integration. Experience in Sales Force CRM Configuration, Customization, Testing of applications. Extensive experience using Sales force Administration (SFA), Custom Objects, Custom Tabs, custom fields, role based Page Layouts, Custom Reports, and Report Folders, Report extractions to various formats, design of Visual Force Pages, Dashboards and various other components as per the client and application requirements,
• Coordinated and developed documentation related to ETL design and development, prepared the ETL best practices document.
• Designing of Salesforce data model creating custom objects, defining relationships as per application requirements.
• Involved in Technical Documentation, Unit test, Integration test and writing the test plan.
• Involved in generating Mload and Tpump scripts to load the data into Teradata table.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Expertise in developing summaries and reports using Advanced Teradata SQL according to business needs.
• Experienced in writing Teradata SQL scripts for transforming business rules.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Extensively used SSIS Import/Export Wizard for performing ETL operations.
• Tracked and supported Agile project with daily stand ups, meeting minutes and Burndown chart.
• Performed & tracked UAT of integrated modules and completed Logging & Tracking Defects in JIRA.
• Scripted SQL queries for data analysis and data extraction during UAT to cross verify the database records.

Environment: Teradata Database, UNIX, Windows server 2003, Informatica PowerCenter 9.x, Automatic UC4, Jenkins, Salesforce, Unix shell programming, Teradata, DB2, Oracle 11g/10g, SQL, PL/SQL, SQL Developer.