Etl Developer Resume
White Plains, NY
SUMMARY
- IT experience on Data Warehousing, Data Analysis, Application Development and Business Intelligence with ETL tools Informatica Power Center 9.1/9.0.1/8.6.1/x.
- Strong technical exposure with good degree of competence in business systems such as Financial, Banking, Insurance and Healthcare.
- Good Knowledge in Ralph Kimball and Bill Inmon methodologies.
- Good understanding of Star and Snowflake Schema, Dimensional Modeling, Data Marts, Relational Data Modeling, Erwin, Microsoft Visio (SharePoint).
- Good experience working on Oracle 11g/10g/9i, PL/SQL, SQL Server/T - SQL, SQL Plus, TOAD, UNIX.
- Knowledge in Installation, Configuration and administration of Informatica Power Center 8/9.x (Server/Client).
- Knowledge on MDM and worked on data profiling, standardization, rules, score cards through Informatica Analyst (thin client), IDE/IDQ of Informatica Developer (thick client) in validating mappings as rules, profile data using join, column, primary and foreign dependency) for flat files, excel and Relational Tables.
- Has noledge for text editing on file comparison tools using notepad++, Exam-Diff.
- Extensively worked on Power Center client: Repository Manager, Mapplet Designer, Mapping Designer, Workflow Manager and Monitor to extract, transform and load data.
- Designed mappings using SQL overrides necessary for pre and post SQL, Source Qualifier, Look up (Dynamic and static), Filter, Router, XML, Union, Update and Expression Transformations.
- Developed common logic using reusable transformations, mapplets, and worklets.
- Worked on Slowly Changing Dimensions (SCD's) and implemented Type1, Type 2 (Flag and time stamp).
- Extensive usage of Sequence Generator, shortcuts and reusable components for sources, targets, transformations, mapplets, worklets and sessions.
- Expertise in documenting the ETL process, STM specifications, status reports and meeting minutes.
- Employed Power Exchange 9.01 HF2 for main frames/flat files importing through data maps and copybooks into server for structures and importing into Power Center Designer.
- Extensively used Informatica to load data into ODS, Data Warehouse on integration of various sources that involve relational databases-Oracle 10g/9i, MS SQL Server 2008/2005, DB2 UDB 8.1, XML and flat files.
- Efficient in troubleshooting mapping bottlenecks, performance tuning and debugging.
- Has noledge and worked for any updates on files, project plans, review HLD, LLD updates in Share point.
- Performed data migration from development to QA, Pre-Test Process, and QA to PROD of SDLC ETL process.
- Had experience with versioning control and static/dynamic deployment of objects between different repositories.
- Experience in Data Profiling, data analysis, parameterizing DB connections, file paths, error handling.
- Well versed with the business functioning, end user requirements gathering and developing process in accordance with the business rules, coming up with data load strategies, unit testing, and integration testing.
- Knowledge of coding ETL Tasks in UNIX Shell scripts to interact with INF server using PMCMD command.
- Used Active Batch and Informatica Scheduler for scheduling batch cycle jobs for running on Unix using PMCMD command, FTP connections and further file editing using UNIX shell scripts.
- An Energetic, flexible, well organized, self-motivated fast learner with minimal supervision, independent and team-oriented, process focused professional in various team sizes performing cross functional roles in challenging environment.
- Excellent analytical, problem solving, communication and interpersonal skills.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center9.1/9.0.1/8.6.1/x (Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor), Power Exchange 9.0.1,Informatica Developer(IDE/ IDQ), Informatica Analyst 9.1
Data Modeling: Relational and Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Erwin, MS Visio
Databases: Oracle 11g\10g\9i, PL/SQL, MS SQL server 2008/2005 R2, UDB DB2 8.1, SSIS/SSRS, MS-Access, Teradata V12
Programming: SQL, Unix, SQL Tuning/Optimization, C
Tools: TOAD, SSIS, SQL *Plus, SQL* LOADER, MS Office, ILM, Active Batch, SSRS, cognos.
OS: Sun Solaris, Unix/Linux, Windows 7/98/95/NT/2000/2003/XP/Vista.
PROFESSIONAL EXPERIENCE
Confidential, White Plains, NY
ETL Developer
Responsibilities:
- Gathering requirements from Team Lead and implement them into source to target mappings in landing, staging and ODS.
- Interacting with Business Analysts in understanding the Database requirements whenever debugging is required without changing the code.
- Focused on new system and tools with minimal supervision and trained Project Architecture to team members.
- Involved in populating data from flat files, XML files into SQL Server 2008 R2 database from landing to ODS (Staging) and into EDW using the common code.
- Worked with file comparison using command and notepad++ tools.
- Worked on 837 EDI Files and Transactions that are converted to flat files by BizTalk for Eligibility emphasized on Medicaid and Non-Medicaid Demographics for Prescribers, Subscribers relatively with other data elements
- Involved in generating and applying rules to profile data for flat files and relational data by creating rules in IDE and case cleanse, parse, standardize data through mappings in IDQ and generated as mapplets in PC.
- Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions.
- Developed functions, packages and procedures applied in Informatica through external procedure transformation.
- TEMPEffectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
- Extensively used Sequence Generator in all mappings and fixed bugs / tickets raised in production for existing mappings in common folder for new files through versioning (Check in and Check out) on an urgency through support for QA in component unit testing and validation.
- Used shortcuts for sources, targets, transformations, mapplets, and sessions to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
- Applied slowly changing Dimensions Type I and Type II on business requirements.
- Parameterized all mapping, session parameters, DB connections wherever necessary in sandbox and common folder and tested links in DEV, QA, and PROD for populating data into SQL, and updated whenever necessary for migrations in different environments at root directory.
- Worked on Pre/Post SQL with indexes, T-SQL to improve performance and avoid changes in common code.
- Extensively worked on performance tuning and also in isolating header and footer in single file.
- Performed code migration of mappings and workflows from Development to Test and Production through deployment groups for DEV, TEST and PROD repositories in retaining shortcuts, dependencies with versioning.
- TEMPEffectively understood session error logs and used debugger to test mapping and fixed bugs in DEV in following change procedures and validation.
- Tuned and optimized mappings to reduce ETL run time and ensuring they ran within designated load window.
- Documented as Run Book for all providers, Eligibility related mappings into their respective spread sheets to run in a sequence from landing to Staging to ODS for Active Batch (ran in sequential for client loads and concurrent for same customer needs) and Cleansing Data before the feeds into EDW
- Raised change requests, analyzed and coordinated resolution of program flaws and fixed them in DEV and Pre-Production environments, during the subsequent runs and PROD.
- Perform analysis profiling on existing data and identify root causes for data inaccuracies, Impact Analysis and recommendation of Data Quality.
- Precisely documented mappings to ETL Technical Specification document for all stages for future reference.
- Employed Active Batch as Job Automation tool for running daily, weekly and monthly loads through UNIX PMCMD command for each workflow in a sequence with command and event tasks.
- Involved in meeting minutes for status reports, updates, any issues for any change procedures to Lead, Manager.
- TEMPEffectively played a multi dynamic role facing all challenges and managed working on similar projects as well.
Environment: Informatica Power Center 9.1,IDQ, Active Batch, SQL Server 2008,T-SQL,Flat Files, XML files, Windows 2003, JIRA(assigning tickets/issues), RFC for Change Requests, MS Visio
Confidential, Atlanta, GA
Informatica Developer
Responsibilities:
- Involved in Project Life Cycle of application access issues to Implementation phase.
- Working closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking Team on Proxy server and proving support on the databases and applications
- Gathering requirements from Business Analyst’s in understanding the Databases and Structures required for masking in star schema data model.
- Good Knowledge on applying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformation and loading into targets.
- Designed, developed and tested mappings to move data from source to staging load followed with data cleansing.
- Worked on parameterizing DB connections using UNIX scripts in /server/bin and updated connections, hardcoded data in parameters for mappings and sessions in all environments when ready for harvest.
- Employed Power Exchange 9.0.1 for flat files and mainframe files for GDG’s, in which they are rearranged and edited for proper reading of files and avoiding errors.
- Extensive use ofPersistent cacheto reduce session processing time for all applications where masking necessary on substitution, primary key constraints and relatively when deploying made faster.
- Worked on identifying Mapping Bottlenecks in Mappings and improved session 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 reusable UNIX shell scripts command in Pre/Post Sessions.
- Migrated mappings and folders from one repository through import/export, .rep files from Version 8.6.1 to 9.0.1 and also through static/dynamic deployment groups following versioning check in and checkouts for source and target repositories.
- Worked on Serena Dimensions in version control for a record history of version 8.6 and 9.0.1 versions of Informatica at DEV, SIT and PROD environments and deployment.
- Ensured that system testing and change management procedures are followed with an ability to prioritize and manage multiple tasks with TEMPeffective time management skills.
- Precisely documented all data for further reference.
Environment: Informatica Power Center 9.0.1/8.6.1 HF2, Oracle 10g/9i, MS SQL Server 2000, IBM DB2/400, Flat files, Main Frames, MS Visio, Toad 7.0, Windows 2000, Linux, Putty, ILM Work Bench, Power Exchange 9.0.1, Serena Dimensions.
Confidential, NJ
Sr. Informatica Developer
Responsibilities:
- Gathered requirements and developed mappings to maintain metadata in Repository to load data from Oracle. SQL Server, flat files into Oracle targets.
- Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
- Handled Data Conversion functions and defined constraints, indexes and views based on requirements.
- Worked on mapplets and created parameter files wherever necessary to facilitate reusability.
- Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
- Used Error Handling to capture data errors in error tables to correct and reprocess them by analysis and error remediation Process.
- ImplementedCDCby tracking the changes for critical inserts/updates by user.
- Created database maintenance planner for SQL performance: include Database integrity checks and re-indexing.
- Worked on Pre Session and Post session UNIX commands for file connections through Informatica server.
- Modified the existing mappings for the updated logic and better performance.
- Avoided Duplicate issues through SQL override using look up, Joiner transformations.
- Used Explain, trace, stored utilities in performance check and also applied table partitioning in tuning.
- Performed Unit Testing on the mappings based on HLD, LLD codes and developed plans based on pending transaction strategies on credit cards.
- Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping and handled process errors through emails.
- Actively participated in resolving Email tasks working on priority and non-priority issues.
- Developed and Scheduled jobs for daily loads that invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables for batch process.
- Handled running logs through Unix scripts and edited files through Vi editor.
- Ensured that integration testing and system testing followed with QA and change management procedures.
Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, MS SQL Server 7.0/2000, Flat files, SQL*Loader, Erwin 3.5, Toad 7.0, Unix, windows 2003, UNIX.
Confidential
ETL Data Developer
Responsibilities:
- Prepared the Technical and Function specifications based on the project requirements.
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL.
- Configured packages using Package configuration wizard to allow package run on different environments.
- Developed PL/SQL stored procedures to process and load data into data warehouse.
- Used Execution Plan, SQL Profiler & database engine tuning advisor to optimize queries.
- Created package for data conversion using various transformations tasks.
- Used BIDS to build reports using the wizards and designers, and deploy them to Report Server.
- Extracted Data from sources: SQL Server oracle and Flat files to load into ODS (staging area).
- Applied partitioning at session for data loads using target lookup to avoid duplicate records.
- Implemented Mapping Variables and Parameters in Transformations.
- Reduced complexity and time using re-usable components: worklets, Mapplets, and transformations.
- Implemented Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
- Utilized Informatica tasks: Session, Command, Timer, Email, Event-Raise, and Event-Wait.
- Created Parameter file for session parameters and called in the sessions.
- Used Debugger wizard to remove bottlenecks at source, transformation, and target for optimum loads.
- Worked with session logs, Error Handling and validated data populated by Unit and Integration testing.
- Developed documentation for activities of developed methods related to information processing metrics.
- Worked with QA team and fixed bugs that were reported and validated code in the mappings.
Environment: IPC 7.1/8, SQL Server 2000, SSIS, Flat Files, TOAD 8.0, Oracle 9i, DB2, Windows 98/2000