Background Summary

• Experienced Informatica developer with 8+ years of experience in IT industry in data warehousing , involving analysis, development and both Manual and Automation testing.
• Experience of working extensively in Agile Environment (Agile /scrum model) and good expertise in attending Scrum calls, Sprint Planning, Reviews and retrospective meetings.
• Extensive knowledge in SDLC: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica Power center 10.2/10.1/9.6/9.5.
• Possess specific experience in the Banking, and Insurance and Pharma Domains.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling like star schema and snowflake schema
• Strong SQL query skills using an enterprise wide RDBMS (Oracle, MS SQL Server & MS Access) and strong with concepts of SQL queries ranging from DML, DDL and TCL.
• Created procedures, triggers using PL/SQL
• Strong RDBMS concepts and experience in creating, maintaining and tuning tables, Stored Procedures User Defined Functions and System Functions using SQL Server, T - SQL
• Strong experience in Informatica tools Repository manager, Designer, Workflow manager, Workflow monitor. Ability to Work with complex mappings using different transformations like Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator
• Experience in developing the mappings, mapplets, reusable transformations in designer and scheduling the workflows and sessions in work flow manager.
• Strong knowledge in debugging mappings and using mapping parameters and variables for incremental loading of data and session parameters for migrating workflows.
• Performed various data cleansing activities using informatica data quality (IDQ)
• Performed data profiling, data cleansing, data parsing, data standardization using IDQ
• Experience with Teradata tools fast export, multiload, parallel transporter
• Knowledge in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies
• Work closely with DBA teams to troubleshoot data issues and enhance database performance
• Expertise in unit testing at various levels of the ETL as well as SQL.
• Expert working with Databases like Teradata, Oracle 11g , SQL Server.
• Experience in generating web intelligence reports using Micro strategy
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement Experience working with Onside-Offshore model.
• Ability to work independently or in a team environment or in a rapid pace environment.
• Willing to relocate: Anywhere
• Authorized to work in the US for any employer

TECHNICAL SKILLS:

ETL/BI Tools: Informatica Power Center 10.1/9.6/9.1, Informatica data quality 360, AUTOSYS

Database Tools: PL/SQL developer, SQL navigator, Teradata SQL Assistant

Programming Languages: SQL, PL/SQL, Unix, Shell Scripting. Basic python

BI Tools: Business Objects, MicroStrategy 2019

Testing: HP Quality Center, Query Surge

Oracle 11g/10g/, MS: SQL Server 2012/2008, Teradata 10 amp

Business Applications: Word, Excel, Access, Project, PowerPoint

PROFESSIONAL EXPERIENCE:

DATAWAREHOUSE ANALYST / DEVELOPER

Confidential, NJ

Responsibilities:

• Participated in Business Requirements and analysis discussion meetings.
• Interacted with business users to get required changes and implement them in code and Interacted with production support team to understand existing code.
• Creates requirements, data mappings, workflows and ER diagrams, BRDs for data warehouse loading and data transformation processes.
• Provides requirements, rules, data mappings and diagrams to technical teams, including data warehouse and data integration developers.
• Analyzed Data Specification Documents ( IDD, IFS ) and implemented their logic in the form of Informatica mapping design.
• Developed Sequence diagrams, Business flow diagrams and Activity diagrams based on Integration requirement.
• Interacted with different middleware teams like TIBCO, SAP and Liaison team to get technical requirements and developed informatica interfaces accordingly.
• Consult with SOA Team for Integration with Messaging & Component Services with upstream/downstream applications.
• Re-designed existing PowerCenter mappings to implement change requests (CR) representing the updated business logic.
• Performed unit testing to ensure logic is achieved and helped process team to perform SIT .
• Developed SHELL script to start informatica job and get email notification on status of jobs and summary of informatica job run.

Environment: Informatica Power Center.10.2, SQL developer, Teradata SQL assistant, TIBCO, Liaison, UNIX Shell Scripts.

Data Warehouse Developer/Informatica Developer

Confidential, Philadelphia, PA

Responsibilities:

• Responsible building enterprise Datawarehouse for examinees.
• Having involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Designed, developed and tested mappings to move data from different databases to one enterprise warehouse.
• Lead a team of 2 Junior Developers to deliver the products.
• Established coding standards/naming standards in various technologies like Informatica, Oracle database tables
• Analyzed system documentation like Requirements documents, Gap analysis user interface specifications to develop technical document of the business flow to design, develop, and execute the mappings.
• Worked on identifying Mapping Bottlenecks in Mappings and improved session performance and mapping performance by including partition points, modifying target load order and emphasizing more on SQL override in Lookup, Source Qualifier, Filter, and Update strategy, functions in expression transformations.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases
• Executed pre and post session commands on source and target database using UNIX shell scripting.
• Reviewed, analyzed, and ensured the quality of data loaded into the database system by utilizing IDQ imported, sorted, cleaned, and transformed data according to business objectives
• Created reference tables to perform standardization, parsing, cleansing, of data
• Involved in quality assurance of data, automation of processes.
• Developed python scripts to parse JSON source files and automate data load process.
• Documented and maintained technical documentation regarding the extract, transformation and load process.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• As per business requirement, designed developed and maintained MicroStrategy based reports.
• Decommission old reporting tool (DISCOVERER) and transitioning over to MicroStrategy by recreating all reports

Environment: Informatica Power Center.10.1, PL/SQL Developer, SQL navigator, Active Batch, Oracle 11g, PL/SQL, MicroStrategy, UNIX Shell Scripts.

ETL INFORMATICA DEVELOPER

Confidential, NY

Responsibilities:

• Analyzing the Functional Specifications and changing necessary modifications required through onsite team interaction.
• Understanding/analyzing the requirements& providing solutions for issues related with same which covers activities like: requirement analysis, ETL designing, scheduling workflows and providing Maintenance, Enhancement & Support to the Client.
• Prepare the ETL Specifications for business logics.
• Involved in Dimensional modelling (Star Schema) of the Data warehouse and designed dimensions, facts based on user requirement
• Designed the Data Warehouse/ ETL processes using Informatica Power Center 9.6 to extract, transform and load data from multiple input sources like SQL Server, flatfiles and Oracle to target Teradata database
• Created temporary database (preparation DB) to load preparation data.
• Created complex mappings using various transformations such as Rank, Joiner, Expression, Lookup (Connected/Unconnected), Aggregate, Filter
• Created BTEQ files with set of complex SQL queries and stored procedures, triggers (PL/SQL)
• Coordinate with application development team to achieve success in design, development and deployment activities
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Timer and scheduling of the workflow.
• Performed tuning of SQL queries for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
• Involved in tuning of mappings and sessions for better performance
• Modified existing mappings for enhancements of new business requirements.
• Migrated the code into QA (Testing) and supported QA team
• Created mapplets, mappings to ensure data is upto standards in IDQ developer
• Performed various data quality checks to ensure accuracy, correctness, data consistency, data completeness in prod environment
• Prepared migration document to move the mappings from development to testing
• Prepared mapping document to explain flow of data from source to target.
• Generated web intelligence reports using BOXIR3 on ad-hoc basis
• Extensively involved with backend testing by writing complex SQL queries
• Developed unit/assembly test cases and UNIX shell scripts to run along with daily /weekly /monthly batches to reduce or eliminate manual testing effort.
• Used Teradata fast export to dump data from DB to flatfiles
• Focused on data quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity

Environment: Informatica 9.6.1, Teradata, Oracle 11g, BO, HP ALM, query surge, UNIX, XML, CSV files, SQL Developer, MS Excel, Windows 10

INFORMATICA DEVELOPER

Confidential, Baltimore, MD

Responsibilities:

• Involved in understanding Business Process and coordinated with Business Analysts to understand specific user requirements.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/ Workflows.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer
• Created shell scripts to kick off Informatica workflow/s and PL/SQL procedures.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Extensively worked on tuning mappings and reducing processing times.
• Worked with DBA to identify source and target bottle necks.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Involved in production support for the data warehouse Informatica jobs.
• Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica 9.1, Oracle 10g/11g, Business Objects, IBM DB2, Quality Center, MYSQL, SQL, TOAD, PL/SQL, Teradata, AutoSys

SQL DEVELOPER

Confidential

Responsibilities:

• Analyzing different user requirements and coming up with specifications for the various database applications
• Worked with internal and external clients for import and normalization of third-party data.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Developing RDBMS using STAR and SNOWFLAKE SCHEMA
• Monitored the performance of the database and checked on the execution time
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
• Created views to ensure the data security by providing limited data to users based on requirement.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed SQL query performance tuning by creating and modifying indexes and changing the query structures.
• Used Informatica Designer to create basic mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL DEVELOPER, PL/SQL, Windows NT, UNIX Shell Scripts.