SUMMARY

• With 12+ years of IT experience in Analysis, Design and Development as a Senior Software Developer on Client/Server applications in developing strategies for ETL (Extraction,
• Transformation and Loading) mechanism using Informatica Power center in complex, high volume Data Warehousing projects.
• Extensive experience in ETL design, development and maintenance using SQL, PL/SQL, Informatica Power Center 10.x/9.x/8.x on UNIX and Windows Platforms.
• Strong Data Warehousing ETL experience of using Informatica Power Center 10.x/9.x/8.x, Client Tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server Manager.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, Oracle PL/SQL. Proficient in Toad.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Experience in Change data capture (CDC) and Strong understanding of OLAP and OLTP Concepts.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, and UDT.
• Modified and developed new reports and few dashboards using Tableau tool for enhanced visualization of the data.
• Experience in using Automation Scheduling tools like Autosys and Tivoli job scheduler.
• Extensive experience in unit testing, System testing and test data management.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multiload, Fast Export, Tpump, Visual Explain, and Query man), Teradata parallel support and Unix Shell scripting.
• Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
• Involved in Performance tuning and peer review of code and using IDQ to test and compare the data in different tables.
• Built logical data objects (LDO) and developed various mappings, Mapplet/rules.
• Extensively Designed SCD 1, SCD 2 mappings.
• Experience working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau .
• Performed Data validation, data profiling, data quality, data analysis and statistical analysis using SQL scripts, Tableau Dashboards and MS Excel.
• Experience working in AGILE METHODOLOGY and ability to manage change effectively
• Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin, MS Visio and ER-Studio.
• Experience in Data Modeling and database designing with Business Process Re-engineering (BPR) and Information Engineering (IE) methodologies.
• Experience in Administrative activities such as creating folders, assigning security permissions to users and creating repositories, setting up groups/users permissions in Informatica Repository Manager and admin console.
• Proficiency in data warehousing techniques for data cleansing, surrogate key assignment.
• Involved in full life cycle development of Data Warehousing.
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER.
• 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.
• Extensive experience in managing teams/On Shore-Offshore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, businesspeople and developers across multiple disciplines.
• Experience in writing Batch and PERL Scripting to create and Execute the MAXL rule file while loading into Oracle Hyperion ASO/BSO.
• Experience in writing PERL script to create rule files and CALC method creations while loading into Hyperon Essbase.

TECHNICAL SKILLS

Functional: Project Management, Team Building, Team Leader, Business Analysis and Development, Excellent Communication and Interpretation skills

Technical: Informatica Power Center (10.1, 9.5, 9.1, 8.6, 8.1), IBM Data Stage 9.1, SSIS, SSRS, SQL Server DTS packages, Oracle Hyperion Essbase 11.1.0, Oracle 10g/9i, MS SQL Server 2008/2000, Teradata 15.0, Control M, AutoSys, Agile Model

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale - Arizona

Sr. Informatica Lead

Responsibilities:

• Developed, configured, coded, tested and debugged new software solutions.
• Developed, tested and implemented enterprise datamovement (ETL and CDC) solutions.
• Scheduled the sessions to extract, transform and load data in to warehouse database on Business requirements from REST API.
• Worked extensively on HTTP Transformation to extract data from API.
• Parsing JSON and XML format API from source REST API.
• Addressed system defects and implemented enhancements to existing functionality.
• Worked with onshore/offshore team to analyze, develop and improve ETL run times as well as to produce accurate defect free code.
• Maintained productive working relationships with project sponsors and key systems users.
• Analyzed the business and functional requirements and provided high level technical design specifications to drive ETL Development efforts.
• Troubleshooted issues with minimal guidance, identified bottlenecks in existing data workflows and provided solutions for scalable, defect-free applications.
• Participated in the definition of application scope and objectives through research and fact finding.
• Involved in Extraction, transformation, loading and Implementation.
• Worked on Informatica tool - Source Analyzer, Mapping Designer and Transformations.
• Identified and tracked the slowly changing dimensions’ tables, heterogeneous sources and determined the hierarchies in dimensions.
• Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, SQL server, oracle and loading to Oracle target database.
• Extensively used various types of transformations such as source qualifier, Expression, Joiner, Update strategy, Lookup, Dynamic Lookup, Router, Normalizer, Union, Filter, Sorter, Rank, Sequence generator etc. to load the data.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed Mapping Optimizations to ensure maximum Efficiency.
• Used Informatica features to implement Type 1, which keeps current data.
• Implemented complex mapping such as Slowly Changing Dimensions (Type II) using current Flag.
• Created sessions to run the mappings and set the session parameters to improve the load performance.
• Writing Shell scripts to invoke Informatica workflow, EACS scripts and wrapper scripts.
• We undergo discussion to understand the requirement.

Confidential, Blue Ash - Ohio

Sr. Informatica Lead

Responsibilities:

• Build partnerships across the application, business and infrastructure teams.
• Interacted with Business users/customers to confirm the requirements needed for developing and modifying the jobs and to identify the various sources of data in operational systems and developed strategies to build data warehouse.
• Analyzed the business and functional requirements and provided high level technical design specifications to drive ETL Development efforts.
• Actively involved in the Design and development of the STAR schema data model.
• Designed ETL specification documents to load the data in target using various transformations according to the business requirements.
• Extensively worked with Informatica Power Center to load data from flat files, oracle and other source systems into target database.
• Designed and developed Complex Informatica mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank for populating target tables/Files in an efficient manner.
• Designed and developed ETL workflows with job dependencies and scheduling, participated in code reviews of ETL processes.
• Created Visio diagrams of ETL process to include in the design documents.
• Created check-lists for coding, reviewing, bug logging, troubleshooting, testing and release for smooth functioning of the entire project.
• Created and Configured Workflows, Worklets, and Sessions to load the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Wrote Unix Scripts to invoke Informatica Workflows and sessions.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Implemented Error handling logic to capture Invalid/Null records coming from staging tables.
• Tuned and optimized ETL jobs for performance and throughput.
• Created test plans for unit testing, integration testing and UAT .
• Developed SQL Scripts and ad-hoc queries for data verification and validation processes.
• Managed QA and PROD deployments and automation of ETL Jobs.
• Provided assistance in diagnosing production problems related to the project.

Confidential, Lake Forest - IL

Sr. Informatica consultant (ETL Developer)

Responsibilities:

• Led the Data Integration team to drive detailed ETL and data requirements to ensure accurate capturing of client's business requirements and deliverables.
• Involved in strategy development, project planning, and resource planning, allocation and budget management.
• Acted as the Subject Matter Expert for ETL and Sales Comp.
• Collaborated with IT and Business Teams to gather high-level Integration/Compensation requirements.
• Designed and built ETL solutions to automate the data feeds from client systems
• Go to guy on all data integration project related questions in Professional Services
• Took the lead on building custom Process Queuing system for the data Integration processes giving customers the visibility into the current status of their processes.
• Worked with Cross Functional Teams on various initiatives.
• Involved in all phases of our company’s evolution from a Start Up to an Enterprise.
• Extensively worked on standardizing our methodologies to meet the industry standards with focus on quality, scalability and reusability.
• Always lived up to our Core values of CARE (Customer Focus, Accountability, Respect and Excellence).

Environment: Informatica Power Center 9.0, Oracle 10 g, Flat files, Git migration, STASH, UNIX, Shell Scripting, Xactly Connect, JIRA