SUMMARY

• A detail oriented professional with over 6 years of experience in Analysis, Development, Testing, Implementation and Maintenance of Data Warehousing/Integration projects and noledge on administrator part as well.
• Extensive experience in gathering and analyzing requirements, Gap Analysis, Scope Definition, Business Process Improvements, Project Tracking, Risk Analysis, and Change ControlManagement.
• Expertise in providing end to end BI solution by configuring metadata and building Analytics Repository, dimensional modeling design, building business models, generating reports and creating dashboards.
• 6 plus Years of IT experience in development, Implementation and Testing of various projects on Data Warehouse projects.
• Skilled in Planning, Designing, developing and deploying Data warehouses/Data Marts
• Strong experience in designing and developing Business Intelligence solutions in Data warehouse/Decision support systems using ETL tools.
• Extensively worked on ETL tools using Informatica 9.6.5.1/8.6.1/8.6.5.1 (Power Center/ Power Exchange, Power Mart and IDQ), Oracle11g/10g,Teradata14/13
• Experience in Informatica Big Data Developer Edition and Autosys.
• Through noledge of Relational & Dimensional models (Star & Snow Flake), Facts and Dimension tables, Slowly Changing Dimensions (SCD).
• Involved in migration of Informatica from 8.x to 9.x.
• Extensively worked on Data Visualization tools like Tableau and Qlikview.
• Comprehensive noledge of Software Development Life Cycle (SDLC), Waterfall development process, Agile - SCRUM development methodology, RDBMS, OLTP, ETL, OLAP, and DW Concepts.
• Expert in PL/SQL Stored Procedures, Triggers and Packages.
• Improved in performance tuning by using Explain Plan, creating appropriate indexes, queries optimization, utilizing tables paces and partitioning schemes.
• Hands on Experience in SQL, UNIX, Shell Scripting, Data Relationships, Data extraction & Validation.
• Sources worked various sources and targets included Flat Files, Excel files and Databases, xml and web services.
• Extensive experience developing complex mappings with Custom Transformations, XML Sources, Web Services Consumer.
• Extensively worked on performance tuning of Informatica Mappings and Sessions by implementing parallelism, partitioning and caching
• Resolving data issues, complete unit testing and complete system documentation for ETL processes
• Comprehensive noledge in Dimension modeling concepts like Star Schemas and Snowflake Schemas.
• Experience on creating detailed project outlines and application design specifications.
• Experience in analyzing and executing business specification documents, developing test plans, defining test cases, developing xml test scripts.
• Involved extensively in GUI, System Testing and Regression Testing.
• Good experience in AIX & UNIX working environment.
• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn teh new cutting edge technologies.
• Ability to quickly analyze and -up with an efficient industry standard solution for a given problem.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x, Informatica Power Exchange 9.x/8.x, IDQ 9.6/9.1

BI Tools: OBIEE (10G, 11G), Tableau.

Scheduling Tools: Control-M, Autosys

Languages: C, Java, C++, Python, R.

RDBMS: Oracle/ Exadata/11g/10g, DB2V9, Teradata14/13, PL/SQL, SQL Server 2008

Tools: /Utilities: Toad, Perl, UNIX Shell, Business Objects XI R1

Operating Systems: Windows, UNIX, Linux

Web Technologies: HTML, CSS, XML, JAVA SCRIPT

PROFESSIONAL EXPERIENCE

ETL Informatica Developer

Confidential, Houston, TX

Responsibilities:

• Involved in direct conversations with teh Business users and gather teh requirements to how to handle teh source data and design accordingly teh ETL process.
• Used Informatica Power center 9.6.1 to extract teh data from Insurance application AS400 to transform and load teh data into teh Enterprise Data Warehouse & Data Mart.
• Developed logical data models and physical data models with experience in Forward and Reverse Engineering using ERwin.
• Involved in Information administration including creating new users and groups, backing up teh repository and domain as well as handling various upgrades.
• Used Informatica B2B data exchange to handle EDI (Electronic Data Exchange) for handling teh payments for teh scheduled dates.
• Used major components like Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
• Implemented various data modeling schemas such as star schema and snowflake schema.
• Used Informatica features to implement Type II changes in slowly changing dimension tables.
• Involved in development of Informatica mappings and also tuned session by increasing block size for better performance.
• Used different MDM concept for data transformation, normalization, error -detection and error-correction.
• Various transformations (Source qualifier, Normalizer, Aggregators, Connected &unconnected lookups, Filters, Sequence generator) were used to handle situations depending upon teh requirement.
• Implemented various process of data cleanup and data validation using Informatica Data Quality.
• Involved in Informatica Admin tasks like creating folders, permissions to teh developers.
• Used TOAD to develop oracle PL/SQL, DDL's, and Stored Procedures. Performance and fine Tuning of SQL & PL/SQL stored procedures.
• Schedule and Run Extraction and Load process, monitor task and workflow using teh Workflow Manager and Workflow monitor.
• Created dynamic SQL to execute dynamic queries at runtime.
• Used error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Worked extensively with parameterizing teh workflows, configuring teh reusable success and failure mails, command tasks.
• Experienced in unit testing and development testing at ETL level in mappings.
• Experienced in Agile Backlog prioritization and management.
• Experienced in designing, development, and unit testing of Java.
• Working on new projects to fulfill teh business needs.
• Documented teh scope of new development projects.
• Involved in writing and modifying UNIX shell scripts.
• Worked with data quality team to fix teh production data issues and also provide solutions to teh business users.
• Maintained weekly status report to keep teh project manager updated on teh status of report development.
• Actively participate in planning and status meetings with teh Strategic Solutions team.
• Involved in providing teh solutions for application support and maintenance.
• Coordinated with offshore team to support teh existing ODS system jobs.
• Coordinated with business users and across teh development teams in implementing new business requests.

Environment: Informatica Power Center 9.6.1, Oracle 10g, Oracle E-Business Suite 12.1.3, Informatica PowerExchange 8.6, ERWIN 4.x, DB2 UDB, UNIX (Sun-Solaris), UNIX (AIX 6.2), SQL Loader, Autosys, MS Visio, Flat files, Shell Scripting, PL/SQL, TOAD, Windows XP.

ETL/Informatica Developer

Confidential, Chicago,Downtown

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
• Developed business requirements document (BRD) based on business objectives, facilitated joint sessions.
• Coordinating with onsite and offshore team, review their work and updating management on timely basis.
• Worked on data modeling, created logical and physical level design, maintained dictionary.
• Analyzed business and system requirements to identify system impacts.
• Created flow diagrams and charts.
• Created teh Detail Design Documents which have teh ETL technical specifications for teh given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with teh clients for teh Approval of teh process.
• Analyzed teh existing mapping logic to determine teh reusability of teh code.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per teh requirements.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Created, Tested and debugged teh Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Developed restart token on UNIX server for Real-time Informatica workflows and customized real-time Power Exchange workflows.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Used OBIEE DAC to Schedule teh Informatica mappings in teh correct order, dependencies between them based on teh sources and targets.
• Configured teh workflow to remember teh last time data was extracted from teh source and configured parameter for each mapping so that only changed records can be extracted teh next time it is run.
• Created and maintained teh Shell Scripts and Parameter files in UNIX for teh proper execution of Informatica workflows in different environments.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported teh UAT for teh client.
• Performing ETL & database code migrations across environments.

Environment: Informatica PowerCenter 9.5/8.6, Power Exchange 9.5, Toad, UNIX Shell Scripting, Oracle 11g, SQL Server, Flat Files, Mercury Quality Center, MS Project, HL7, IBM Initiate, OBIEE DAC, Putty, WinScp, Jira, SVN.

Informatica Developer

Confidential, Boston, MA

Responsibilities:

• Extensively used ETL to load data from wide range of sources such as flat files and legacy systems
• Developed transformation logic and designed various Complex Mappings and Mapplets using teh Designer.
• Used Informatica - Big Data Edition and worked with Hadoop.
• Established connection between Informatica and hadoop using hadoop connector.
• Worked on Informatica PowerExchange for Hadoop integrated with Informatica PowerCenter to move data into and out of Hadoop in batch and real time.
• Implemented Machine Business Rules in Informatica and used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Update Strategy, Router and Sequence generator.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Extensive use of Static and Dynamic cache to reduce session processing time
• Identified performance issues in existing sources, targets and mappings by analyzing teh data flow, evaluating transformations and tuned accordingly for better performance
• Maintained warehouse metadata, naming standards and warehouse standards for future application development
• Used Workflow Manager for creating, validating, testing and running teh sequential and concurrent sessions
• Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
• Designed data model for teh custom application for use by Business Analysts, using Erwin
• Extensively involved in Fine-tuning teh Informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions
• Optimized and modified teh triggers, complex store functions, procedures, user base data type.
• Involved in Unit testing and User Acceptance Testing to check whether teh data loads into target are accurate, which was extracted from different source systems according to teh user requirements
• Preparing and using test data/cases to verify accuracy and completeness of ETL process
• Used Sever manager for session management, database connection management and scheduling of jobs to be run in teh batch process
• Actively involved in teh production support and also transferred noledge to other team members
• Responsible for creating business solutions for Incremental and full loads
• Created scripts to create and delete temporary files at teh session level
• Analyzed large data sets by running Hive queries and Pig scripts.
• Extensively used AutoSys and Tidal for scheduling teh Informatica Workflows using UNIX Shell Scripting.
• Actively participated in problem solving and troubleshooting for teh applications implemented with Informatica.

Environment: Informatica 9.6, UNIX, Oracle 11g, SQL server, AutoSys, Hive, Pig, Hadoop.

Informatica Developer

Confidential

Responsibilities:

• Worked with business analysts in gathering teh requirement.
• Extensively involved in analyzing teh huge data in teh data ware house to understand teh amount of duplicates, distinct values in order to determine teh key column.
• Designed mappings for dimensions and facts.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter and Router for developing mappings.
• Created reusable transformations and Mapplet and used with various mappings.
• Performed Unit Test, System Integration Test and UAT to check teh data quality for each task implemented for this application.
• Designed and tested Control-M jobs to trigger teh Informatica workflows.
• Used Debugger in Informatica Power Center Designer to check teh errors in mapping.

Environment: Informatica Power Center 9.1/8.6, Oracle 10g, PL/SQL, SQL, Flat Files, Unix, Control-M, SQL Server 2012.

ETL/DB Developer

Confidential

Responsibilities: 

• Prepared teh ETL design documentations and Unit test case.
• Work on onsite-offshore model. Participated in daily status call with offshore and onsite team.
• Review progress of development and promptly updating clients.
• Developed and reviewed mappings to extract data from flat files into staging tables and from teh staging area to teh dimension tables and fact table.
• Extensively worked on Data Integration of data from various database source systems and mainframe Cobol and VSAM files.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per teh requirements.
• Error handling is done by validating teh records and bifurcating teh data into valid/invalid records and loading teh erroneous records into teh error table.
• Used SQLT to update teh status of teh records in teh error log table when valid records are received from teh source system.
• Designed and developed process for Auditable, which is used in teh mappings to capture teh run statistics.
• Extensively involved in performance tuning of teh ETL process by determining teh bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Expert in tune code using partitioning like round robin, hash auto key, key range and caching at mapping and session level.
• Maintained Development, Test and Production mapping, migration using Repository Manager also used Repository Manager to maintain teh metadata, Security and Reporting.
• Worked on teh UNIX shell scripts to create job to run teh workflows by scheduler.
• Reviewed Informatica code, SQL code and UTC docs.
• Performed three levels of Unit testing, validated data and documented status and bugs using Jira.
• Wrote scripts for bulk load process MLOAD and FLOAD. Worked extensively on BTEQ.
• Worked on teh System integrated testing and supported teh IST and UAT phases of teh project.
• Interacted with upstream and business partners in providing feedback and recommendations for system testing and additional requirements.
• Supported clients through testing, troubleshooting and deployment of teh solution.
• Involved in production support and resolving environment and report issues proactively.
• Tracing heat tickets and maintain noledge database for that to resolve issues quickly in future.

Environment: Informatica PowerCenter 9.1, SQL Server 2000, TD Utilities, SQL Assistance, Linux, Autosys 7, Putty, WinScp, Jira, Teradata 13.0, XML, Web Services, SCM.