PROFESSIONAL SUMMARY:

• 8+ years’ experience in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing Applications using tools like Informatica, Oracle and Unix.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases (Teradata, Oracle, SQL SERVER, DB2) and Flat Files.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Good in data modeling knowledge in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimensions tables.
• Experience in creating and executing SQL Queries to database such as MS-SQL Server, MySQL, and Oracle.
• Experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis, and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional data modelling
• In depth knowledge of Oracle Identity Manager, Oracle Access Manager and Directory Services.
• Expertise in installation and configuration of Oracle Identity Manager (OIM), Oracle Access Manager (OAM), Oracle Directory Server Enterprise Edition (ODSEE).
• Strong understanding of SDLC & Processes used for software development including Waterfall, Agile methodologies.
• Experience in Cross-functional team coordination with Architects, Developers, Data Teams, Business teams and key stakeholders to ensure project success.
• In depth knowledge of Managing the identification, development and prioritization of bug fixes and software enhancements.
• Good in data analytics to identify corporate business risks, leading to the project development.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.0/9.6/8.x, InformaticaPowerExchange9.6/8.x

Operating Systems: Windows XP/Vista/7/8/10 Macintosh, Linux, Mac OS

Modeling and Wireframe tools: Balsamiq, Rational Rose, MS Vision

SDLC Methodologies: Agile, Waterfall, SCRUM, RUP

Business Skills: Change Management, Impact Analysis, JAD Sessions, SWOT analysis, Project Planning

Requirement & Project Management Tools: JIRA, Asana, Trello, MS Project, MS SharePoint Server, Rational Requisite Pro, Rally

Testing Tools: HP QC v10.0, HP ALM V11.5, Load Runner

Microsoft Tools: Word,MS Excel functions and pivot tables

Reporting tools: MS Office Suite, Crystal, Tableau Desktop, Business Objects

Languages: HTML, XML, SQL, PL/SQL, Linux, UNIX Shell Scripting, Java, C, C++

Databases: MS SQL Server, MS Access, Oracle 11g/10g, TeraData

EXPERIENCE:

Sr. ETL Developer

Confidential, Rockford, IL

Responsibilities:

• A seasoned ETL developer with 6 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application system for Retail, Banking, Insurance & Manufacturing.
• Strong Data Warehousing ETL experience of using Informatica 10.0.1/9.1/8.6.1/ PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience with dimensional modelling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.

Sr.ETL Developer

Confidential - Austin, TX

Responsibilities

• Involved in creation of HLD and LLD document based on BR and got those reviewed by customers along with detailed project time lines.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Designing the ETLs and conducting review meets Involvement in implementation of BTEQ jobs.
• Wrote appropriate code in the conversions as per the Business Logic using BTEQ, Fast Exports, Multi loads and Fast Load scripts.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases and user guides.
• Coding using BTEQ SQL of TERADATA, wrote UNIX scripts to validate, format and execute the SQL's on UNIX environment.
• Created mapping documents to outline data flow from sources to targets. Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in performance tuning of the Informatica Power Center Mappings/Sessions.
• Used Self-CAT for validating, promoting, importing and exporting jobs from development environment to testing environment.
• Created ETL reusable processes for Error handling & Audit tracking.
• Created test cases for Unit testing and System testing.
• Developed Processes to cleanse the source data as per Business Supplied Cleansing rules.
• Wrote complex SQL Queries to extract data from GE Sales Management systems • Extracted Data from Different SAP Source systems tables using Informatica.
• Created schedulers for daily running of workflows to populate data into warehouse.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Developed Informatica processes to extract data from source to staging.
• Developed ETL processes to load various ODS tables, Dimensions and Facts.
• Applied transformation rules by leveraging wide variety of Informatica transformations like SQL, lookup, aggregate and router transformations, etc.
• Generated sessions and workflows and applied suitable properties for improvising the performance.
• Performed Unit testing the implemented solutions in development and testing environment and deploying them in Production.
• Tuned the performance of jobs by following Control-m best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Scheduling jobs and implementing dependencies if necessary using Control-m.
• Managed post production issues and delivered all assignments/projects within specified time lines.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Involved in Migrating the Informatica objects using Unix SVN from Dev to QA Repository.
• Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.

Environment: MS SQL Server 2014/ 2012/2008 R2/2008, SQL Server Data Tools (SSRS /SSAS/SSIS), T-SQL Enterprise Manager, C#, Microsoft Azure, Data Factory.

Informatica/ETL Developer

Confidential, - Irving, TX

Responsibilities:

• Worked on building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in the installation and configuration of Informatica Power Center 10.1 and evaluated Partition concepts in Power Center 10.1.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created stored procedures, views, user defined functions and common table expressions.
• Generated underlying data for the reports through SSIS exported cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in IDS Services like building Business logics, analyzing the structure and data quality, creating a single view of data etc.
• Worked on Informatica cloud for creating source and target objects, developed source to target mappings.
• Involved in importing the existing Power center workflows as Informatica Cloud Service tasks by utilizing Informatica Cloud Integration.
• Involved in Data integration, monitoring, auditing using Informatica Cloud Designer.
• Worked on Data Synchronization and Data Replication in Informatica cloud.
• Written PL/SQL scripts created stored procedures and functions and debugged them.
• Created Mapplets, reusable transformations and used them in different mappings. Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads and Developed reports based on issues related to the data warehouse.
• Used different Informatica Data Quality transformations in the Developer and Configured match properties match paths, fuzzy match key, fuzzy and exact match columns.
• Experience in optimization and query performance tuning in Netezza using various techniques involving distribution analysis, data-type analysis, zone maps etc.
• Created profiles, rules, scorecards for data profiling and quality using IDQ.
• Used Informatica Data Quality for addresses and names clean-ups and developed error handling & data quality checks to pull out the right data.
• Used IDQ to cleanse and accuracy check the project data, check for duplicate or redundant records.
• Used debugger to test the mapping and fix the bugs and identified the bottlenecks in all levels to tune the performance and Resolved the production support tickets using remedy.
• Developed monitoring scripts in UNIX and moved Data Files to another server by using SCP on UNIX platform.
• Extensively used Teradata Utilities like Fast-Load, Multi-Load, BTEQ & Fast-Export.
• Created Teradata External loader connections such as M Load, Upsert and Update, Fast load while loading data into the target tables in Teradata Database.
• Involved creating the tables in Teradata and setting up the various environments like DEV, SIT, UAT and PROD.

Environment: Informatica Power Center 10.1, Oracle12C, Informatica Cloud, IDS 9.6.1, IDQ 9.6.1 Teradata 14.0, SQL Server 2014, Teradata Data Mover, Autosys Scheduler Tool, Netezza, UNIX, Toad, PL/SQL, SSIS, Power Connect, DB2, Business Objects XI3.5.

Informatica/ETL Developer

Confidential

Responsibilities:

• Collected business, system, and functional requirements related to user account and lifecycle management by conducting detailed interview with clients, business users, stakeholders, and Subject Matter Experts (SME's).
• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
• Communicated with business customers to discuss the issues and requirements.
• Designed, documented and configured the Informatica MDM Hub to support loading, cleansing of data.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Developed ETL programs using Informatica to implement the business requirements.
• Developed several IDQ complex mappings in Informatica a variety of Power Center, transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using Informatica Power Center.
• Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).
• Used Informatica Power Center to load data from different data sources like xml, flat files and Oracle, Teradata, Salesforce.
• Migrated servers from 1and1 to AWS Elastic Cloud (EC2), databases (RDS).
• Developed the SQL scripts for the business rules using Unix Shell and NZSQL for Netezza.
• Imported the IDQ address standardized mappings into Informatica Designer as a Mapplets.
• Utilized of Informatica IDQ to complete initial data profiling and matching/removing duplicate data
• Used relational SQL wherever possible to minimize the data transfer over the network.
• Identified and validated the Critical Data Elements in IDQ.
• Built several reusable components on IDQ using Standardizers and Reference tables which can be applied directly to standardize and enrich Address information.
• Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions) Type 1 and Type 2
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, and Aggregator Transformation.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Used the Teradata fast load utilities to load data into tables
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Converted all the jobs scheduled in Maestro to Autosys scheduler as the per requirements
• Worked on maintaining the master data using Informatica MDM
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows)
• Performed tuning of queries, targets, sources, mappings, and sessions.
• Used Linux scripts and necessary Test Plans to ensure the successful execution of the data loading processWorked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.

Environment: Informatica Power Center 10.1, UNIX, SQL, IDQ, IDE, CDC, MDM, Java, Linux, Perl, AWS, WINSCP, Shell, PL/SQL, Netezza, Teradata, Microsoft SQL Server 2008, and Microsoft Visual studio

OIM Analyst

Confidential, Denver, CO

Responsibilities:

• Worked on designing, implementation and management of OIM, including capacity, performance, availability, automated provisioning, and event management.
• Worked on multiple OOTB and custom connectors like Active Directory connectors to support both trusted and target reconciliation.
• Implemented Role and Attribute Based Access Policies using Oracle Access Manager.
• Developed OIM schedule tasks to auto revoke the access in OIM and generate Request ID when User transferred or terminated use cases.
• Designed and customized OIM Adapters to carry-out auto provisioning and de-provisioning.
• Generated automated daily reports using custom shell scripts to reduce time efforts in finding discrepancies by analyzing logs.
• Worked closely with various technology teams and provided technical expertise to guide them on integration projects.
• Maintained continuous improvement through the development and support of effective KPIs and Service level agreements.