PROFESSIONAL SUMMARY:

• Around 7 years of strong experience in all phases of life cycle of Requirement Analysis, Functional Analysis, Design, Development, implementation, Testing, Debugging, Productions Support, and Maintenance of various Data Warehousing Applications.
• 8 years of experience in designing and development of ETL Methodology using Informatica PowerCenter 10.2/9.0.1/8. x, Informatica PowerExchange 10.2/9.0.1, Informatica DataQuality 9.0.1.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and Data marts and Data warehouse.
• Expert in performance tuning of Informatica mappings, identifying source and Confidential bottlenecks.
• Experience in Bill Inmon and Kimball data warehouse design and implementation methodologies
• Expertise in OLTP/OLAP System Study, E - R modeling, developing Database Schemas (Star schema and Snowflake schema) used in relational and dimensional modeling.
• Extensive Experience in integration of various data sources like ORACLE 12c/11g/10g, Teradata 14/13, Netezza, UDB DB2, Mainframes, SQL server 2012, SAP, Sybase, Informix, MySQL, Flat Files, JSON and XML
• Experience on Informatica Cloud Integration for Amazon Redshift and S3
• Implemented Slowly Changing Dimensions (SCD) Type 1 and Type 2 for initial and history load using Informatica.
• Expert in Performance tuning, troubleshooting, Indexing and partitioning techniques on Sources, Targets, Mappings and Workflows in Informatica.
• Expertise in Teradata utilities like Multi Load, Fast Load, Fast Export, BTEQ, TPUMP, TPT and tools like SQL Assistant, Viewpoint
• Well-versed in tuning Teradata ETL queries, remediating excessive statistics, resolving spool space issues, applying compression for space reclamation etc.
• Proficient in Data Analysis, Data Validation, Data Lineage Data Cleansing, Data Verification and identifying data mismatch
• Extensive experience in Data analysis, ETL Techniques, MD5 logic for loading CDC.
• Experienced in writing UNIX shell scripts, SQL Loader, Procedures/Functions, Triggers and Packages.
• Superior SQL skills and ability to write and interpret complex SQL statements and also mentor developers on SQL optimization and ETL debugging and performance tuning
• Exposure of end to end SDLC and Agile methodology
• Skilled in creating & maintaining ETL Specification Documents, Use Cases, Source to Confidential mapping, Requirement Traceability Matrix, performing Impact Assessment and providing Effort estimates, deployment artifacts
• Worked many years in onsite offshore model. Provided technical design leadership to ensure the efficient use of offshore resources and the selection of appropriate design, ETL/CDC logic.
• Extensive experience of providing IT services in Financial, Retail and Banking industries.
• Strong Knowledge of Hadoop Ecosystem (HDFS, Hive, Impala etc.)
• Have good problem solving, time management skills, communication skills, self-motivated, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center ( 10.2/9.0.1/8. x), PowerExchange 9.6.1/9.0.1 , Informatica DataQuality 9.0.1, Power connect for SAP BW, power connect for JMS, power connect for IBM MQ series, power connect for Mainframes, DTS

BI Tools: Business Objects 5.1, Cognos Impromptu 6.0, Powerplay 6.6, and Oracle 9i Discoverer.

Data Modeling: ERwin 9.5.2/7.3/4.1 , MS - Visio 2013, UML, Oracle designer.

Databases: Teradata 14/V2R6/V2R5, Oracle 12c/11g/10g/9i, SQL Server 2012/2005, UDB DB2,MySQL, Sybase, Informix, Amazon Redshift, MS Access

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

Big Data: Hadoop Ecosystem (HDFS, Hive, Impala)Cloud Computing

Amazon Web Services (AWS), S3, Redshift

MS: DOS, HP UNIX, Windows and Sun OS.

Methodologies: Ralph Kimball s Star Schema and Snowflake Schema.

MS Word, MS Access, T: SQL, TOAD, SQL Developer, Microsoft Office, Teradata View Point, Teradata SQL Assistant, Icescrum, JIRA,, Control - M, Autosys, GitHub

PROFESSIONAL EXPERIENCE:

Confidential, TX

Informatica Developer/ Data Analyst

Responsibilities:

• Co-ordination from various business users’ stakeholders and SME to get Functional expertise, design and business test scenarios review, UAT participation and validation of data from multiple source.
• Defined and developed brand new standard design patterned, ETL frameworks, Data Model standards guidelines and ETL best practices
• Provided technical design leadership to this project to ensure the efficient use of offshore resources and the selection of appropriate ETL/CDC logic.
• Performed detailed data investigation and analysis of known data quality issues in related databases through SQL
• Actively involved in Analysis phase of the business requirement and design of the Informatica mappings.
• Performed data validation, data profiling, data auditing and data cleansing activities to ensure high quality Cognos report deliveries·
• Used various transformations of Informatica, such as Source Qualifier Transformation, Expression Transformation, Look-up transformation, Update Strategy transformation, Filter transformation, Router transformation, Joiner transformation etc. for developing Informatica mappings.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Teradata utilizes like BTEQ, FASTLOAD, MLOAD, and FASTEXPORT.
• Created sessions and work-flows for the Informatica mappings.
• Heavily used Informatica Cloud integration using Amazon Redshift connector and integrated data form various sources
• Configured sessions for different situations including incremental aggregation, pipe-line partitioning etc.
• Created mappings with different look-ups like connected look-up, unconnected look-up, Dynamic look-up with different caches such as persistent cache etc.
• Created various Mapplets as part of mapping design.
• Involved in writing Oracle stored procedures and functions for calling during the execution of Informatica mapping or as Pre or Post session execution.
• Created effective Test Cases and performed Unit and Integration Testing to ensure the successful execution of data loading process.
• Documented Mappings, Transformations and Informatica sessions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Extensively involved in testing by writing some QA procedures, for testing the Confidential data against source data.
• Written Unix shell scripts for file manipulation, ftp and to schedule workflows.
• Co-ordinated offshore team on daily basis to leverage faster development.

Environment: Informatica PowerCenter 10.2, Informatica DataQuality 10.2, Amazon Redshift, Cognos 10.0, Sun Solaris, AWS S3 Bucket, JSON, SQL, PL/SQL, Oracle 12c, TOAD, SQL Server 2014, MySQL, Shell Scripting, Rally, JIRA, Teradata 15, Control - M, GitHub, hdfs, Hive

Confidential, Wilmington, DE

Informatica Developer/ Data Analyst

Responsibilities:

• Participated in the Design Team and user requirement gathering meetings.
• Extensively used Informatica Designer to create and manipulate source and Confidential definitions, mappings, Mapplets, transformations, re-usable transformations.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
• Used Star Schema approach for designing of database for the data warehouse
• Developed a standard ETL framework to enable the reusability of similar logic across the board.
• Created different Confidential definitions using warehouse designer of Informatica Power center.
• Created different transformations such as Joiner Transformations, Look-up Transformations, Rank Transformations, Expressions, Aggregators and Sequence Generator.
• Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.
• Extracted source data from Oracle,SQL Server, Flat files, XML files using Informatica, and loaded into Netezza Confidential Database.
• Extensively transformed the existing PL/SQL scripts into stored procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
• Used PL/SQL whenever necessary inside and outside the mappings.
• Created Models based on the dimensions, levels and measures required for the analysis.
• Validate the data in warehouse and data marts after loading process balancing with source data.
• Created, launched & scheduled sessions.
• Fixed Performance issue in Informatica mappings.
• Teradata utilizes like BTEQ, FASTLOAD, MLOAD, and FASTEXPORT.
• Customized Unix shell scripts for file manipulation, ftp and to schedule workflows.
• Created design specification which includes BI dependency plan, job scheduling and cycle management documents
• Worked closely with the business analyst’s and Production Support to resolve any JIRA issue.
• Co-ordinated offshore team on daily basis to leverage faster development.

Environment: Informatica PowerCenter 9.0.1, Informatica PowerExchange 9.0.1, Informatica DataQuality 9.0.1, Cognos 9.0, Linux, SQL, PL/SQL, Oracle 11g, TOAD, Teradata 14, SQL Server 2012, Autosys, Shell Scripting, XML, SQL Loader

Confidential

ETL Developer

Responsibilities:

• Involved in design and development of data warehouse environment, liaison to business users and technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
• Using Informatica Designer designed Mappings, which populated the Data into the Confidential Star Schema on Oracle Instance.
• Optimized Query Performance, Session Performance and Reliability.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled the batches to be run using the Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Performed Unit testing and Integration testing on the mappings in various schemas.
• Optimized the mappings that had shown poor performance
• Monitored sessions that were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the sessions.
• Coordinated between the development and testing teams for robust and timely development of fully integrated application.
• Constantly monitored application attributes to ensure conformance to functional specifications.
• Mentored the development members on ETL logic and performed code and document reviews

Environment: Informatica PowerCenter 8.1, Informatica, SQL Server 2005, Oracle 10g, Shell Scripts, Erwin, TOAD, UNIX, Cognos 8, SQL, PL/SQL, UNIX, Toad, SQL Developer, HP Quality Center