SUMMARY:

• Around 7 years of IT experience in all phases of Software Development Life Cycle (SDLC) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing and distributed applications.
• Excellent domain knowledge of Banking, Finance and Telecom.
• Expertise in using ETL Tool Informatica Power Center 8.x/9.x/10.2 (Mapping Designer, Workflow Manager, Repository Manager and ETL concepts.
• Extensive knowledge in RDBMS, Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle (SDLC).
• Hands on experience working on Waterfall Model as well as Agile Model, implementation of various sprint.
• Interacted with end - users and functional analysts to identify and develop Business Requirement Documents (BRD) and transform it into technical requirements.
• Strong experience with Informatica mapping i.e. Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy, and Stored Procedure from varied transformation logics in Informatica.
• Worked with Teradata various utilities like Fast Load and Multi Load and Tpump and Teradata Parallel transporter and highly experienced in Teradata SQL Programming.
• Experienced in Teradata Parallel Transporter.
• Expertise in tuning the performance of Mappings and sessions in Informatica and determining the Performance bottlenecks.
• Having strong hands on experience in extraction of the data from various RDBMS source systems like DB2, Oracle, SQL Server etc.
• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system.
• Loaded diverse types (Structured, JSON, flat files etc.) into the Snowflake cloud data warehouse.
• Extensively used multiple Slowly Changing Dimension (SCD-Type1,2,3) technique in ETL Transformation.
• Very good understanding of OLTP/OLAP, E-R diagram, Dimensional Models, Star schema, Snowflake schema etc.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets. Created debugging and performance tuning of sources, targets, mappings, transformations and sessions.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Package, Functions, Triggers, Views, Materialized Views.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using PMCMD command. Extensively used Autosys for Job monitoring and scheduling. Automated the ETL process using UNIX scripting.
• Worked on converting logical data models to physical database designs in Data Warehouse environment, Data Integrity concepts and Data Analysis.
• Excellent communication skills, interpersonal skills, self-motivated, quick learner and outstanding team player.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (10.2/9.x/8.x), PowerExchange 9x, power connect for IBM MQ series, power connect for Mainframes

BI Tools: Cognos 10.0 /9.0, QlikView, Tableau 9/10

Data Modeling: ERwin 9.5.2/7.3/4.1, MS - Visio

Databases: Oracle 11g/10g, IBM UD2 DB2, MS SQL Server, MS Access 2000, Teradata 13/12/V2R5, Snowflake cloud data warehouse, MySQL, PostgreSQL

Languages: PL/SQL C++, C, UNIX Shell Scripting, SQL, PL/SQL.

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

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

Methodologies: Ralph Kimball’s Star Schema and Snowflake Schema.

Others: Microsoft Visio, TOAD, Oracle SQL developer, winSCP, TOAD, SQL Loader, MS Office, FTP, Ultra Edit, Autosys, Control-M, HP Quality Center, T-SQL, Teradata View Point, Teradata SQL Assistant, Icescrum, Rally, JIRA, GitHub

PROFESSIONAL EXPERIENCE:

Confidential, Floral Park, NY

Sr. Informatica Developer / Data Analyst

Responsibilities:

• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Worked with slowly changing dimension Type1, Type2, and Type3.
• Loaded nested JSON into the Snowflake cloud data warehouse from AWS S3 bucket
• Maintained Development, Test and Production Mappings, migration using Repository Manager. Involved in enhancements and Maintenance activities of the data warehouse.
• Performance tuning of the process Confidential the mapping level, session level, source level, and the target level.
• Wrote complex SQL query for data profiling and matching/removing duplicate data for the process of data migration from the legacy systems to the target ORACLE Database.
• Created dictionary tables for data validations.
• Heavily used BTEQ script for loading data into target table
• Worked on loading of data from several flat files to Staging using Teradata MLOAD, FLOAD and BTEQ.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency.
• Strong on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Customize shell scripts to run mapping in Control M
• Understanding the entire functionality and major algorithms of the project and adhering to the company testing process.

Environment: Informatica PowerCenter 10.2, Oracle 11g, DB2, Teradata 15, MSSQL Server 2012, Snowflake cloud databases, AWS S3 bucket, JSON, Erwin 9.2, Putty, Shell Scripting, Clearcase, Putty, WinSCP, Notepad++, JIRA, Control-M, Cognos 10.

Confidential, Boston, Massachusetts

Sr. Informatica Developer

Responsibilities:

• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
• Worked with slowly changing dimension Type1, Type2, and Type3.
• Maintained Development, Test and Production Mappings, migration using Repository Manager. Involved in enhancements and Maintenance activities of the data warehouse.
• Performance tuning of the process Confidential the mapping level, session level, source level, and the target level.
• Utilized SQL query to complete the initial data profiling and matching/removing duplicate data for the process of data migration from the legacy systems to the target Oracle Database.
• Designed and developed Informatica DQ Jobs, Mapplets using different transformation like Address validator, matching, consolidation, rules etc. for data loads and data cleansing.
• Heavily used bteq script for loading data into target table
• Worked on loading of data from several flat files to Staging using Teradata MLOAD, FLOAD and BTEQ.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency.
• Strong on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Worked with SQL*Loader to load data from flat files obtained from various facilities.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Understanding the entire functionality and major algorithms of the project and adhering to the company testing process.

Environment: Informatica PowerCenter 9.1.1, Oracle 11g, Teradata 14.0, Teradata SQL Assistant, MSSQL Server 2012, MySQL, Erwin 9.2, Putty, Shell Scripting, BitBucket, WinSCP, Notepad++, Rally, Control-M, Tableau 9.2.

Confidential, New York, NY

Informatica Developer / Data Analyst

Responsibilities:

• Understood business requirements, logical modeling, physical database design, data sources and data loading strategy.
• Participated in data analysis, data profiling, and data dictionary and metadata management. Heavily used SQL for data profiling.
• Collaborated with Business users to collect requirements and prepared ETL technical specifications
• Developed, supported and maintained the ETL processes for exporting data from other application into reporting data mart using Informatica Power center 8.5.1
• Designed, built and maintained mappings, sessions and workflows for the target data load process using Informatica, PL/SQL and UNIX.
• Implemented customer history data capture for catalogue tables using SCD Type 2.
• Designed mappings for Slowly Changing Dimensions, used Lookup (connected and unconnected), Update strategy and filter transformations for loading historical data.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Worked with SQL*Loader to load data from flat files obtained from various facilities.
• Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.
• Worked extensively with Informatica tools such as Source Analyzer, Warehouse Builder and Workflow Manager.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression and sequence generator transformations in extracting data in compliance with the business logic developed.
• Wrote SQL overrides in source qualifier to filter data according to business requirements.
• Wrote Unix shell scripts for scheduling Informatica pre/post session operations.
• Created different parameter files and started sessions using these parameter files using pmcmd command to change session parameters, mapping parameters, and variables Confidential runtime.
• Tuned the mappings by removing the Source/Target bottlenecks and Expressions to improve the throughput of the data loads.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, Toad, SQL Developer, UNIX, Cognos 8.2, PL/SQL, Autosys, Putty, WinSCP

Confidential, Minneapolis, MN

Informatica Developer / Data Analyst

Responsibilities:

• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Worked on ETL design and development, creation of the Informatica source to target mappings, sessions and workflows to implement the Business Logic.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data
• Used most of the transformations such as the Source qualifier, Aggregators, Lookups, Filters, Sequence and Update strategy, Router.
• Extensive knowledge and worked with Informatica Data Quality (IDQ 8.6.1) for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data.
• Designed and developed Informatica DQ Jobs, Mapplets using different transformation like Address validator, matching, consolidation, rules etc. for data loads and data cleansing.
• Preparation of technical specification for the development of Extraction, Transformation and Loading data into various stage tables.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.

Environment: Informatica PowerCenter 8.5.1, SQL Server, Oracle 11g, Flat files, MySQL, Teradata 13, WinSCP, Notepad++, Toad, Quest Central, UNIX scripting, Windows NT.

Confidential, Minneapolis, MN

Informatica Developer / Data Analyst

Responsibilities:

• Assisted to prepare design/specifications for data Extraction, Transformation and Loading
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads Confidential required frequency using Workflow Manager.
• Prepared reusable transformations to load data from operational data source to Data Warehouse.
• Wrote complex SQL Queries involving multiple tables with joins.
• Worked with complex queries for data validation and reporting using SQL and PL/SQL.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Used debugger, session logs and workflow logs to test the mapping and fixed the bugs.
• Analyzed the dependencies between the jobs and scheduling them accordingly using the Work Scheduler.
• Improved the performance of the mappings, sessions using various optimization techniques.

Environment: Informatica 8.1, PL/SQL, OBIEE, Erwin, Oracle 10g, SQL Server 2008, Flat files, SQL, putty, UltraEdit-32, shell Programming, Toad, SQL Developer, UNIX scripting, Windows NT