We provide IT Staff Augmentation Services!

Lead Etl/architect/informatica Developer Resume

4.00/5 (Submit Your Rating)

Los Angeles, CA

EXPERIENCE SUMMARY

  • 9+ years of experience in the IT industry and wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation of the business technology solutions
  • Experience in Data Warehouse/Data Mart development life cycle with thorough knowledge in Star schema, Snowflake schema, Dimension and Fact tables.
  • Worked in various Industry sectors Such as Healthcare, Travel, Global Trade and Banking.
  • Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment
  • Worked as a Technical Lead for Onsite as well as offshore team.
  • Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica PowerCenter 9.1/8.6/7.1/6.1/5.1 and IDQ tool.
  • Created mappings using Lookup, Aggregator, Joiner, Expression, Filter, Router, Update strategy and Normalizer Transformations. Developed reusable Transformation and Mapplets.
  • Testing and fixing the bugs in Mappings and testing for loading performance.
  • Understanding of Ralph Kimball methodology for Dimensional Data Modelling, Star Schema and Snowflake Schema. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, Slowly Changing Dimensions.
  • Extensive experience in using tools like SQL Plus, TOAD, SQL Loader, PL/SQL Developer and Knowledge in databases and operating systems like MS Access, MS SQL Server 2000/2005, IBM DB2 7.2/8.0,and Windows 2000/XP.
  • Extracted data from various sources like Oracle, Flat file, SQL SERVER, and loaded into Flat File and Oracle database.
  • Experience in migrating application code from one Environment to another like Dev to QA to PROD.
  • Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLSETL Tools: Informatica Power Center 9.1/8.6/7.1, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Informatica Developer, Informatica Analyst, IDQ,SQL *Plus, Toad

Databases: Oracle 10g/9i/8i, MS SQL 2000/2005, MS Access 2000

Programming: SQL, PL/SQL, Unix

Environment: Windows 95/98/NT/2000/XP, UNIX(AIX 5.2), Linux, MS - Dos

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data ModelingPROFESSIONAL HISTORY

Confidential, Los Angeles, CA

Role: Lead ETL/Architect/Informatica Developer

Responsibilities:

  • Analyzed the Data Integrity Gathering process which is sufficiently robust to measure and assess the flow and quality of the information throughout the complete data lifecycle
  • Analyzed the requirements and documented how and when Data from the different Bank Systems should be mapped, extracted and loaded into the Data Quality Repository.
  • Established an effective and efficient Data Quality assessment process that can examine the integrity of key data elements of each business transaction across a myriad of source systems, models and reports Bank wide using Dashboards and summary reports.
  • In collaboration with data stewards, involve in develop and maintain databases and data systems necessary for projects and department functions
  • Acquire and abstract primary or secondary data from existing internal or external data sources
  • Designed Mappings and procedures to extract, transform and load the commercial and Real estate data from the different number of source systems with the quality data using IDQ by creating Profiles.
  • Demonstrated risks and analyzed the development which is developed by my team, and provided solutions
  • Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
  • Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner and Stored Procedure.
  • Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
  • Created profiles using Informatica IDQ for analyzing data quality for the business rules in which pass, fail percentage is populated in the BO reports
  • Used HP Quality Center tool to log and maintain defects during different phases of testing.
  • Used HP Service Manager (change management) for code migration from different environments.
  • Monitor for timely and accurate completion of select data

Environment: Informatica 9.1/9.5, Informatica Data quality 9.5, Oracle 10g/11g TOAD, Flat files and SQL, Autosys (For Scheduling)

Confidential, Louisville, KY

Role: Lead ETL/Informatica Developer

Responsibilities:

  • Conducted Project Kick-off with all stakeholders and business/functional-leads.
  • Define Project Scope, high-level Project Plan, time-lines, roles and responsibilities.
  • Analyzing the requirement and understanding the functional specifications
  • Facilitate project build, unit testing, integration test cycles, bug fixing and UAT sign-off.
  • Writing code to fetch data from database and applying ETL logic to prepare result in required format.
  • Used Oracle, Flat files, and SQL server sources and Oracle as target
  • Extensively worked with Repository Manager, Designer, Workflow Manager and Monitor.
  • Worked with Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure transformations.
  • Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow
  • Used TOAD to evaluate SQL execution.
  • Performance monitoring and tuning
  • Integration of various applications
  • Bug Fixing of the application in various areas
  • Conducting code review.
  • Prepare Deployment, Roll-back and Communication Plan and ensure smooth deployment on Production Environment.

Environment: Informatica Power Center 8.6 0 (Workflow Manager, Workflow Monitor, Mapping Designer, Mapplet Designer, Transformations), Oracle 10g, SQL, PL/SQL, UNIX, $Universe (For scheduling)

Confidential, NY

Role: Sr. ETL/Informatica Developer

Responsibilities:

  • Analyzing the requirement.
  • Understanding the functional specifications document.
  • Estimating the effort involved in fulfilling the requirements.
  • Writing the technical design document
  • Writing the code and scripts using PL/SQL and Informatica.
  • Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
  • Created Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Developed tasks like Session, Email, Decision, Assignment, Command, Event Wait and Event Raise.
  • Tested Stored Procedures, functions, Unit and Integration testing of Informatica Sessions and batches.
  • Using Informatica versioning check-in, check-outs, report generation, track the changes in projects and documents on share point portal.
  • Developed mappings according to business rules, naming conventions, mapping design standards and good sound knowledge in Data Warehouse, PL/SQL concepts, ODBC connections etc.
  • Creating Test case documents for Unit Test, Integration Test to check the data and Mapping documents.
  • Writing various types of sql scripts for DDL’s, using different types of loads etc.
  • Unit Testing
  • Bug Fixing of the module in various areas
  • Managing knowledge gained for utilizing it for other module design.
  • Communication to stakeholders - Business partners and IT Management

Environment: Informatica Power Center 8.6 0 (Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), Oracle 10g, Windows 2000, UNIX.

Confidential,

Role: Informatica /ETL Developer

Responsibilities:

  • Defined sources and targets and the business rules that define how the data gets transformed.
  • Extracted and transformed data from multiple sources (Oracle, Sybase, SQL Server, flat file, XML) and loaded into Oracle tables.
  • Development of Informatica mappings with the use of the various Informatica transformations.
  • Involved in creating Best Practice methodologies For Data Migration.
  • Involved in creating, designing and implementation of Core ETL Methodologies using Star and Snowflake schema.
  • Created Unit Test Packets to test data loads and check whether the components adhere to the technical design.
  • Fine-tuned mappings in order to improve performance.
  • Used Workflow Monitor to monitor performance of Jobs.
  • Developed and Implemented Scripts to rectify failed loads.
  • Created UNIX shell scripting to run the sessions workflow for Informatics mappings.
  • Developed SQL Overrides for the Source Qualifiers Based on the Business Requirements.

Environment: Informatica 7.1, ORACLE 9i/10g, UNIX, Win NT 4.0, TOAD Quest Software, Scheduler (Auto Sys)

Confidential,

Role: Oracle Developer

Responsibilities:

  • Performing various activities like DB maintenance, monitoring and optimization.
  • Application level performance tuning of Database.
  • Creating Oracle Forms and writing stored procedures in PL/SQL.
  • Preparing Effort estimates, External and Internal Specifications for various change/enhancement requests.
  • Translating the business requirements into technical requirements.
  • Involved in responding and resolving the support issues within defined service level agreements
  • Defect logging, User Training, Client Meeting

Environment: PL/SQL, Oracle Forms, Oracle 10g, Windows 2000, UNIX.

Confidential, Santa Clara, CA

Role: Oracle Developer

Responsibilities:

  • Maintenance / Support and Development in Global Trade portfolio.
  • Performing various activities like DB maintenance, monitoring and optimization.
  • Application level performance tuning of Database.
  • Writing stored procedures in PL/SQL.
  • Preparing Effort estimates, External and Internal Specifications for various change/enhancement requests.
  • Translating the business requirements into technical requirements.
  • Involved in responding and resolving the support issues within defined service level agreements
  • Defect logging, User Training, Client Meeting.

Environment: HP-UX 11.11, Oracle 9i/10g Database, Pl/SQL and UNIX.

We'd love your feedback!