SUMMARY

• Over 7+ years IT experience with extensive Data Warehousing across Financial, Health care, and Insurance domains.
• 7+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 10.x/9.x/8.x
• Experience in all teh phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Strong noledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snowflake Schema).
• Experience in integration of various data sources likeOracle, DB2, Sybase, SQL server and MS access andnon-relational sources likeflat filesinto staging area.
• Experience in creating Reusable Transformations and Mappings using Informatica Designer and processing tasks using Workflow Managerto move data from multiple sources into targets.
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experienced in UNIX work environment,file transfers,job schedulingand error handling.
• Worked onPerformance Tuning,identifying and resolving performance bottle necks in various levels like sources, targets, mappings and sessions.
• Experience in writing, testing and implementation of theT-SQL/ PLSQL triggers, stored procedures, functions, packages.
• Involved inUnit testing, System testing to check whether teh data loads into target are accurate.
• Experience in support and noledge transfer to teh production team.
• Proficient in interaction with teh business users by conducting meetings with teh clients in Requirements Analysis phase.
• Assign work and provide technical oversight to onshore and offshore developers
• Excellent analytical/ communication skills and good team player.
• Exposed to different methodologies in Software Development Life Cycle - (Agile and Waterfall and Lean).

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x/9.x/8.x, Informatica Power Exchange 8.x

Reporting Tools: Tableau, SSRS, OBIEE 10.1.3.1.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensional Tables, Physical and Logical Data Modeling.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2012/2014, Teradata, My SQL, MS-Access, and Main Frames, DB2.

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, Batch scripting, Jscript/PHP.

Other tools & Utilities: MDM, IDQ, Autosys, Tidal, Control-M, Tortoise SVN, EMDS, GitHub, Business Objects, Toad, MS-Office, Microsoft Visual studio, Service- Now, Web Services

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. ETL Informatica Developer

Responsibilities:

• Involved in all phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Spearheaded a project, and actively participated in requirement gathering with business users and solution designer, functional and technical design discussions with data architect.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with teh concerned stakeholders. Conducted Impact and feasibility analysis.
• Developed Informatica mappings/workflows to load source data from Staging/ODS/EDW layers
• Developed mappings/Reusable Objects/Transformation/mapplets/user defined functions by using mapping designer, transformation developer and mapplet designer in Informatica Power center.
• Performed data manipulations using various Informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Update strategy, sorter and Sequence generator etc.
• Migrate workflows in teh Autosys scheduling tool to operate teh File watcher, log files, email alerts, Daily schedules, file events, job events, variable events to kick of teh Informatica workflows and other batch scripts.
• Written various procedures, functions in SQL Server, and tuned SQL queries to reduced bottlenecks and improve Performance.
• Used SQL tools like SSMS, SQL Developer to run SQL queries and validate teh data in warehouse.
• Involved in performance tuning, query optimization, and modified pre/post SQL commands to add or recreate indexes to increase teh loading performance.
• Deploying teh new development to various environments using Repository Manager from Development to TEST, QA, and PROD environments.
• Migrating teh data from different environments like Development to production for creating shortcuts and by creating deployment groups.

Environment: Informatica Power Center 10.2, SQL Server 2012/2016, Batch Scripts, Sybase, MS-Excel, MS- Access, Autosys, Tidal, HPE-ALM, Jira, Visual Studio, Service-Now, CCNet (EMDS), Unix and Windows 10.

Confidential, Norfolk, VA

Informatica Developer

Responsibilities:

• Analyze, design and develop ETL strategies to resolve issues related to Enterprise data warehouse (EDW) and data marts.
• Extracted Data from sources like SQL Server, Flat files, and developed mappings, sessions and workflows using Informatica Power Center 9.5.6/10.2.
• Modified teh existing mappings for teh updated logic and better performance and Worked on mapplets and created parameter files wherever necessary to facilitate reusability.
• Created Workflowsusing various tasks likeEmail, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Sessionin teh workflow manager.
• Developed various SQLstored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Used SVN and CTU tool to implement teh workflows successfully into teh QA and production.
• Worked with session logs, Error Handling and validated data populated by Unit testing and Integration testing on mappings.
• Prepared ETL mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, Iterative testing to check whether teh data loads into target are accurate, which was extracted from different source systems according to teh user requirements.
• Work with teh Pega application teams to understand data flows, tracking sensitive data elements in lower environments and observing all masking rules which are implemented according to business requirement.
• Widely used JIRA Dashboard to track teh issues and communicate with teh team members upon teh issue.
• Good Knowledge on applying masking rules and policies Power Center workbench for Data Masking Transformation and loading into targets.

Environment: Informatica Power Center 9.5.6/10.2, IDQ, SQL Server 2012/2014, SSIS, SSRS, JIRA, Tortoise SVN, CTU tool, Tidal, MS-Excel, MS- Access and Windows 07.

Confidential, North Kansas City, MO

ETL Developer

Responsibilities:

• Involved in teh complete life cycle development of teh project including Analysis, Design, Development, Testing and Production support.
• Interacted with business analysts to understand and convert business requirements to technical requirements.
• Designed and developed mappings using which involve different sources that include Flat Files, XML files and Relational tables from heterogeneous databases like Oracle, SQL server and DB2.
• Created Mappings using Mapping Designer to load teh data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management ofMDMdata.
• Responsibilities included designing and developing complex mappings using Informatica power center and Informatica developer (IDQ) and extensively worked on Address Validator transformation in IDQ.
• Performed land process to load data into landing tables ofMDMHub using external batch processing for initial data load in hub store.
• Worked on data standardization using teh cleanse functions in InformaticaMDM.
• Implemented Slowly Changing Dimensions - Type me and Type II in various mappings.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used Workflow Manager for Creating, Validating, Testing and running teh sequential, parallel, sessions that perform Full and Incremental Loads to target system.
• Migrated teh data from different environments like Development to production for creating shortcuts and by creating deployment groups.
• Performed Unit testing and Integrated testing for teh objects created at ETL level, with Testers as per testing standards and UAT with Users to check data consistency.

Environment: Informatica Power Center 9.5.1, Windows 2007, SQL Server 2012/2014, Oracle, Flat Files, MS-Access, Crystal Reports, Control-M.

Confidential, Boston, MA

Informatica Consultant

Responsibilities:

• Involved in teh full life cycle development from Requirements gathering process to Design, Development, Testing and Production support.
• Involved in JAD sessions with End users and assisted Business Analysts in preparing Source-Target Mapping, Data Validation and Functional Design and Conversion Specification documents.
• Prepared High-level and Detailed level Design Documents for Extractions, Validations, Transformations and Loading to target systems.
• Worked with team leads and fellow developers in developing estimates for mapping designs and implementation deadlines.
• Extensively used ETL to Extract and Load data from flat files (Xml files, Flat files) and different Relational tables.
• Developed Data Transformations and worked on web services.
• Used Mapping Parameters, and Workflow Variables to fulfill teh business requirements and Environment specific Parameter files for development standards.
• Used SQL tools like SQL Developer, PL/SQL Developer to run SQL queries and validate teh data in warehouse.
• On call Production support and responsible for investigation and implementing corrective and preventive actions for Production issues.

Environment: Informatica Power Center 8.6/9.1, IDQ, MDM, Windows 2007, DB2 9 (Mainframes), Teradata, Oracle, Flat Files, MS-Access, SQL-Developer, Teradata, IDQ, SQL Assistant, Control-M.

Confidential

JR Informatica Developer

Responsibilities:

• Worked closely with BSA's and Team leads in acquiring business & technical requirements, customizations aspects to meet teh warehouse requirements.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center.
• Extensively used different transformations in Informatica - Expression, Filter, Sorter, Sequence Generator, Aggregator, Lookup, Update Strategy, Router, and Joiner.
• Developed mappings to load data in Slowly Changing Dimensions to keep track of historical data.
• Created various tasks, arranged related tasks in different worklets, arranged worklets in workflow depending upon their interdependencies in workflow manager.
• Assisted teh testing team in System Integration Test of teh ETL application.
• Interacted with external, internal users and DBA in troubleshooting problems reported in huge Volume testing ( Million records Data) systems.
• Performed impact analysis, remedial actions and documented on process whenever a new change is made to production mappings

Environment: Informatica8.0, DB2, Sybase, XML, Flat files, Oracle 9i/8i, UNIX, PL/SQL, Windows XP.