Sr.etl Informatica Developer Resume
SUMMARY:
- 8 years of IT experience and specialized capability in building Enterprise Data Warehouse, Data Marts, Operational Data Stores in real industry segments like Finance, Health, Telecom and Retail Using Informatica Power Center 9.6.1/9.5.1/8.6.1/8.1.1.
- Experienced with full life cycle of SDLC - Software Development (Planning, Analysis Design, Deployment, Testing, Integration and Support).
- Expertise in whole life cycle of DWH with Analysis, Modelling review, ETL Design, Performance improvement, Unit/System testing and support. Strong involvement in Understanding Dimensional Modeling - Star and Snow Flake Schema, Identifying Facts and Dimensions.
- Expertise in working with databases Oracle 10g/9i, Teradata 14/12, SQL Server 2000/2005/2008, DB2, My Sql, Sybase. Extensive involvement in creating Stored Procedures, Functions, Views and Triggers, Complex SQL queries.
- Having solid Experience in Informatica and Teradata mix in Enterprise distribution center environment. Having solid involvement in utilizing Teradata utilities like TPT, FASTLOAD, MULTILOAD, and BTEQ scripts.
- Developed mappings in Informatica to stack teh information from different sources into teh Data Warehouse, utilizing distinctive changes like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
- Experience in determining on-going upkeep issues and bug fixes; observing Informatica sessions and in addition execution tuning of mappings and sessions.
- Extensive involvement in composing UNIX shell scripts and computerization of teh ETL forms utilizing UNIX shell scripting.
- Expertise in implementing performance tuning techniques both ETL & Database level.
- Experience in utilizing Automation Scheduling instruments like Autosys, Control-M and Maestro.
- Experience in working both Waterfall & Agile Methodologies. Good relational abilities with solid capacity to connect with end-clients, clients, and colleagues.
TECHNICAL SKILLS
Operating Systems: Windows, Unix, Linux, MS-DOS
Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, E-R Modeling, Microsoft Visio.
RDBMS: Oracle 10g/9i, Teradata 14/13/12, DB2, SQL Server 2000/2005/2008/2012, DB2, MySQL, Sybase
ETL Tools: Informatica Power Center 9.6.1/9.5.1/8.6.1/7.1.1, SQL Server Integration Services (SSIS)
Reporting Tools: Cognos, Business Objects, SSRS
Languages: XML, UNIX Shell Scripting, SQL, PL/SQL
PROFESSIONAL EXPERIENCE:
Confidential
Sr.ETL Informatica Developer
RESPONSIBILITIES:
- Using Informatica Power Center Designer analyzed teh source data to Extract & Transform from various source systems (SQL server and flat files) by incorporating business requirement rules.
- Using Informatica Power Center 9.5.1 as a tool, Extracted data from Flat files, SQL to build Data Source and Applied business requirement logic to load teh Facets, Vendor and Pharmacy data into Data Warehouse Data Mart Tables.
- Designed and developed Mappings using different transformations such as Source Qualifier, Expression, Aggregator, Filter, Joiner, and Lookup to load data from source to target tables.
- Created Stored Procedures to handle teh selection criteria such as Address, Provider, Specialty, Chapters and Credentialing and to load teh data for teh Extract and Exclusion reports based on teh business requirements.
- Created Stored Procedures to load teh crosswalks data for Medicare Provider and Printed Directories to SQL Staging tables.
- Createdvariablesandparametersfiles for teh mapping and session so dat it can migrate easily in different environment and database.
- Worked with re-usable sessions, decision task, control task and email tasks for on success/on failure mails.
- Migration of ETL code from Development to QA and from QA to Production environments.
- Involved in working with business analyst in resolving teh issues related with teh migration of designs fromDev ServertoProd Server.
- PerformUnit testingby writing simple test scripts in teh database and involved inintegration testing.
- Creating and Deploying SSRS reports for teh provider directory Health Plan and vendor data and generate teh daily, weekly, monthly and Quarterly reports.
- Created various batch Scripts for scheduling various data cleansing scripts and loading process.
- Created Subscriptions and generated Subscription ID’s for teh Extract and Exclusion Reports from SSRS Reports.
- Created tidal jobs to schedule teh informatica workflows using Tidal Scheduler.
- Extensively worked on creating technical design documentation.
ENVIRONMENT: Informatica Power Center 9.5, SQL Server 2012, Oracle 11g, Flat Files, SSRS, Microsoft Visual Studio 2012, Tidal, JIRA, Microsoft Visio, SharePoint, Facets, Tortoise SVN.
Confidential
Sr. ETL Informatica Developer
RESPONSIBILITIES:
- Utilized all teh features of Source Qualifier transformation such as filter, joiner, sorter and SQL override to teh extend level at teh source level.
- Worked with Business data Analysts (BDA) to understand teh requirements for EDW development.
- Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Lookup, Filter and Union in developing teh mappings to migrate teh data from source to target.
- Extensively used Lookup transformation and Lookup Caches in looking teh data from relational and Flat Files.
- Extracted data from various heterogeneous sources like Oracle, Sybase, Flat Files and COBOL (VSAM) using Informatica Power center and loaded data in target database DB2.
- Extensively worked with session logs and workflow logs in doing Error Handling and trouble shooting.
- Developed complex SQL queries to develop teh Interfaces to extract teh data in regular intervals to meet teh business requirements and extensively used Utilities & Loaders.
- Involved in doing Unit Testing, Integration Testing and Data Validation.
- Worked with teh Control M scheduling team in scheduling Informatica Jobs as per teh requirement and frequency.
- Implemented various Performance Tuning techniques by finding teh bottle necks at source, target, mapping and session and optimizing them.
- Involved in DWH up gradation for source system changes.
- Created Mapping parameters and Variables and written parameter files.
- Created UNIX shell scripts for various needs.
- Worked with teh Debugger Wizard in debugging teh mappings.
- Used Normalize Transformation for Cobol (VSAM) sources.
- Worked with External stored procedures for data cleansing purpose.
- Worked with teh Cognos team in generating various reports.
- Involved in preparing teh Migration Documents.
- Implemented Informatica Procedures and Standards while developing and testing teh Informatica objects.
- Successful in Providing 24x7 On-call Support for Production databases.
ENVIRONMENT: Informatica Power Center 9.6.1, Oracle, Sybase, DB2, Flat Files, Cobol (VSAM), Win SQL, Toad, Ultra Edit - 32, CDMA, MS-Visio, Cognos, UNIX, Windows XP Professional.
Confidential
ETL Informatica Developer
RESPONSIBILITIES:
- Analyzed teh Business Requirement Documents (BRD) and laid out teh steps for teh data extraction, business logic implementation & loading into targets.
- Responsible for Impact Analysis, upstream/downstream impacts.
- Created detailed Technical specifications for Data Warehouse and ETL processes.
- Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into teh Teradata using Teradata Utilities.
- Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
- Used most of teh transformations such as teh Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
- Extensively used Pre-SQL and Post-SQL scripts for loading teh data into teh targets.
- Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested teh mappings.
- Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.
- Involved in Initial loads, Incremental loads and Daily loads to ensure dat teh data is loaded in teh tables in a timely and appropriate manner.
- Extensively worked in teh performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
- Loaded data in to teh Teradata tables using Teradata Utilities Bteq, Fast Load, Multi Load, and Fast Export, TPT.
- Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing teh Mappings.
- Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
- Integrated teh data into centralized location. Used migration, redesign and Evaluation approaches.
- Responsible for Unit Testing, Integration Testing and halped with User Acceptance Testing.
- Tuned teh performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing teh run time of workflows.
- Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned teh tables in Teradata for optimal performance.
- Scheduling Informatica jobs and implementing dependencies if necessary using Autosys.
- Managed post production issues and delivered all assignments/projects within specified time lines.
ENVIRONMENT: Informatica Power Center 9.1.1/9.5.1, Oracle 11g, DB2, Teradata, Flat Files, Erwin 4.1.2,Sql Assistant, Toad, Winscp, Putty, Autosys, UNIX.
Confidential
Informatica ETL Developer
RESPONSIBILITIES:
- Analysis and evaluation of teh issues faced during development and facilitating speedy recovery.
- Review and analyze data mapping document to determine ETL program design.
- Use Informatica to develop ETL program to extract data warehouse File extract to be created will follow teh instructions specified in teh data mapping and file layout documentation.
- Extracted data from flat files and oracle database, applied business logic to load them in teh central Oracle database.
- Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center.
- Did teh Data Migration from various source systems (DB2 UDB, Siebel, SQL Server) to central oracle data base which is used to business users for easy access of teh data.
- Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
- Responsible for Unit Testing of Mappings and Workflows.
- Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
- Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
- Used Informatica Power Center Workflow manager to create sessions, batches to run with teh logic embedded in teh mappings.
- Extensively used Informatica Debugger for testing teh mapping logic during Unit Testing and also worked with QA teams regarding fixing bugs.
- Using teh Power Exchange for Change Data capture (CDC) option to capture teh data whenever teh inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables.
- Used Control-M scheduler to automate teh process of running sessions and workflows.
ENVIRONMENT: Informatica Power Center 9.1.1, Oracle 10g, SQL, PL/SQL, DB2, SQL Server, XML, MS Access, Informatica Scheduler, Windows 2008, Control M, UNIX-HP, CDC.
Confidential
Informatica ETL Developer
RESPONSIBILITIES:
- Worked with ETL Architects and Senior developers for understanding teh requirements.
- Extensively used transformations to implement teh business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading, SCD.
- Create, schedule Workflows and Worklets using teh Workflow Manager.
- Extensively worked in teh performance tuning of teh programs, ETL Procedures and processes.
- Coded Database triggers, functions and Stored procedures and written many SQL Queries.
- Experienced coding shell scripts for various activities.
- Involved in Tuning Teradata Queries & Experienced using Teradata Utilities BTEQ, MLOAD & FLOAD.
- Performance Tuning of teh Oracle Sql by adopting Explain plans, cutting down query costs using Oracle hints.
- Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using teh Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of teh workflows.
- Optimized teh performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks
- Performed Unit Testing at development level, Source code migration and documentation
- Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
- Managed teh Metadata associated with teh ETL processes used to populate teh data warehouse.
- Involved in solving Trouble Tickets raised by Data warehouse Users.
- Experience with on call support.
ENVIRONMENT:Informatica Power Center 8.5.1, Oracle, Teradata 12, Flat Files, UNIX (AXI), Toad, Maestro, Windows.