PROFESSIONAL SUMMARY:

• 15+ Years of total IT experience in the Business Requirements Analysis, Application Design, Development, Implementations and Testing of Data warehouses and Database business systems for various Verticals like Banking and Health Care.
• 13+ Years of ETL experience using in ETL Tool (Informatica 7.x and Informatica 8.x and Informatica 9.x and Informatica 10.x.
• Good Domain Knowledge and Experience in Banking and Healthcare.
• Experienced in Agile Scrum based system development.
• Involved in the complete life cycle of quite a few Data Warehouse implementations which include ETL Solutions Architecture, Functional/Technical Design, Development - Coding and Testing (Unit Testing, System Integration Testing and User Acceptance Testing) and Implementation.
• Solid hands on experience with data warehousing tools, Data integration, data analysis, data quality, architecting complex ETL process, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Good knowledge in designing the Conceptual, Logical and Physical data modeling using Erwin and Data modeling.
• Good Knowledge in Tableau Desktop 10.2, Business Object 4.1
• Good knowledge of Hadoop ecosystem, HDFS, Big Data, Hive, Pig, Sqoop, Map Reduce, Flume, OoZie
• Good knowledge on Hadoop Cluster architecture
• Conceptual Knowledge and Experience in SQL & PL/SQL
• Extensive experience in extraction, transformation and loading of data directly from heterogeneous source systems like Oracle 8/9i/10g/11g, IBM DB2 9.5, Flat files, XML files, Teradata V15,SQL SERVER, SYBASE
• Strong skills of Informatica Power center - Designer, Workflow manager, Workflow monitor, mapping designer, warehouse designer, various transformations such as source qualifier, expression, joiner, normalizer, router, aggregator,lookup and update strategy, XML Generator, Partitions, PushDown Optimization
• Extensive knowledge and experience in Informatica Data Quality,Trillium Data Quality
• Physical & Logical Data modeling and Hands on experience in Star and Snowflake Schema design in Relational, Dimensional and Multidimensional modeling.
• Involved in Unix Scripts Enhancements & Automations

TECHNICAL SKILLS:

ETL Tool: Informatica 7.1.1/ 8.1.1/8.6/9.1/9.6/10.1/10.2

Reporting Tool: Business Object 4.1, Tableau Desktop 10.2

Data Quality Tool: Informatica Data Quality 8.6

Database: Oracle 9i/10g/11g,Teradata V15,IBM DB2 9.5,SQL Server

Data Modeling Tools: ERwin 9.6

Languages: C, C++, JAVA,Servlet, SQL, PL/SQL,Python

Operating Systems: UNIX, RedHat Linux, Windows 2000/XP

Database Tools: Toad 9.1, RMAN, TKPROF, DBVERIFY, SQL * LOADER

Job Scheduler: Control M, AutoSys, Tidal,ESP

Hadoop Ecosystem: HDFS, Big Data, Hive, Pig, Sqoop, Flume

PROFESSIONAL EXPERIENCE:

Senior ETL Consultant

Confidential

Environment: Informatica 10.2,Teradata V15,ESP, Trillium Data Quality,RubyMine, and Unix

Responsibilities:

• Analyze the existing systems and development strategies come up with the recommendations as per the current ETL Standards.
• Participate in regular status review meetings with the Business.
• Create the solution architecture document which includes end to end architecture by understanding the existing systems.
• Design reusable, and low maintenance ETL Transformations like mapplet, scripts
• Developed Informatica Workflows, sessions and mappings. Applied labels for migration.
• Responsible for developing the mappings from given technical documents using various transformations like Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer, Rank and XML Generator etc.
• Created the Star Schema, loading Dimension and Facts Tables through Informatica.
• Extracted data from different Source systems like Flat files and staged into a single place, applied business logic and loaded to central database.
• Hands on experience with Informatica Pushdown Optimization (PDO), Session Partition against relational RDBMS Teradata.
• Responsible for creating Relational connections, Unit and system integration tests. Created Deployment groups for migration.
• Perform the review of the code which done by other members in team.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments

ETL Solutions Architect

Confidential

Environment: Informatica 10.1,Oracle 11g,CA Erwin,Tidal and Unix

Responsibilities:

• Interaction with business users,Product owner and business analyst for requirement gathering.
• Modeling the tables as per the Corporate standards using Erwin, generation of DDL and coordination with DBA in the creation of tables.
• Used Forward Engineering to generate DDL for creation of physical data model.
• Used CA Erwin to develop data models.
• Enforced standards and best practices around data modeling effort.
• Conducted data model reviews with project team members.
• Break up the work into task list and estimate based on simple, medium and complex methodology in TFS and assign the task to the ETL developer.
• Responsible in managing tasks and deadlines for the ETL teams.
• Gathered requirements from Business and gave IT estimates to Project Manager.
• Developed ETL Solutions architecture design review document in accordance with business requirements.
• Developed ETL Source to Target data mapping document for the requirement.
• Involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.
• Provided proper resolutions for ETL related issues.
• Provided technical support in all phases on ETL enterprise architect life cycle.
• Recommended architectural improvements and designed solutions for better performance and scalability.
• Involved in Implementation plan preparation and code migration activity support for all the environments.
• Coordination with QA team for System Integration Testing(SIT) and User Acceptance Testing(UAT) with Business Users.

Technical Lead

Confidential

Environment: Informatica 9.6.1, Sybase, MS SQL Server, Mongo DB and Unix

Responsibilities:

• Gathered requirements from Business, gave IT estimates to Project Manager.
• Working with architects to create various Data Warehouse data models
• Modeled new data models based on user requirements and updating existing data model. Created new metadata and updating existing metadata.
• Discussed with business clients on providing tactical solutions and designing logical data models accordingly. Worked with clients to generate use case scenarios based on user requirements.
• Verified if the data model helps in retrieving the required data by creating data access paths in the data model.
• Compiling Technical Specification documents from Detail Business requirements documents
• Developed Informatica Workflows,sessions and mappings. Applied labels for migration.
• Responsible for developing the mappings from given technical documents using various transformations like Update Strategy,Router,Aggregator, Sorter,expression, Joiner,XML Generator etc.
• Worked with Informatica 9.6, SQL Server 2012, Sybase, WinSQL and UNIX.
• Extracted data from different Source systems like SQL Server, Sybase, Flat files and staged into a single place, applied business logic and loaded to central database.
• Responsible for creating Relational connections, Unit and system integration tests. Created Deployment groups for migration.
• Developed Korn shell (unix) scripts to schedule jobs and run Informatica workflows.
• Developed the workflows to use dynamically generated and static parameter files, indirect source files. Also used post session command task to send emails to send exception reports to USERS.
• Worked on migrating existing Jobs and integrate it with the new Enterprise Data Warehouse.
• Taking Models / design reviews to Organizational Architectural Reviews.
• Created the Code Review Automation tool using the informatica repository tables

ETL Solutions Architect/ Senior ETL Developer

Confidential

Environment: Informatica 9.1, Teradata and Unix,Control M,SVN

Responsibilities:

• Involved in the Design phase of the Project to give the ETL Design Document
• Mainly involved in ETL coding and designing.
• Designed conceptual data model based on the requirement, Interacted with non-technical end users to understand the business logics.
• Modeled the logical and physical diagram of the future state, Delivered BRD and the low level design document.
• Discussed the Data model, data flow and data mapping with the application development team and Creating mapping for specific business requirements, data analysis for business Users query
• Working with Transformations like Source Qualifier, Lookup, Update Strategy, Aggregator, Router, Expression and Joiner Using Informatica.
• Created informatica mapping and TPT connection to load flat file data into Teradata Staging table and control the TPT user session connection through the Unix script.
• Created BTEQ script to load the data from staging table to integration table in integration layer.
• Created Mapplet and used them in different Mappings.
• Performance tuning using Pass through partitioning.
• Automated the jobs through scheduling using Control M, which runs every week by loading the Customer data.
• Experience of handling "Slowly Changing Dimensions" to maintain the complete History.
• Performed Informatica code migrations in Different Environment.
• Tuning the mappings & Session to enhance the performance by identifying bottlenecks
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the Stage table and dimension tables and fact tables properly.
• Preparation of Unit test plans, System & Integration test plans and Unit and Integration Testing.