We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

Reston, VA

SUMMARY:

  • Over 7 years of IT experience with expertise in Business Analysis, Application Design, Development, Implementation for Banking and Financial Services.
  • Achieved the Project objectives in possible efficient manner keeping in mind the team parameters
  • Employed Informatica to populate data mart from large flat files and databases. Utilized flat files, XML files and RDBMS sources like Oracle according to requirements.
  • Extensive experience of Data warehousing using Informatica PowerCenter9.5/9.1 Client and Server tools.
  • Defined and managed Database Connectivity to Source and Target Databases using Repository Manager and Workflow Manager Tools in Power Center .
  • Extensive experience in designing developing Informatica Mappings & Mapplets using various transformations for Extraction, Transformation and Loading from Multiple Sources(SQL Server, Oracle, Flat files,Teradata SalesForce.com) to Data Warehouse and creating Sessions and Workflows/Worklets and executing the Workflows.
  • Responsible for Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports those are generated from Informatica.
  • Created mappings using SQL , Aggregator , Expression , Joiner transformations , Filter and Various Other Transformations.
  • Worked on Data Synchronization and Data Replication in Informatica cloud .
  • Responsible for performance tuning and error handling of Informatica mappings within The Given Environment Boundaries/Parameters
  • Comfortable knowledge in Autosys Tools and JIL Scripts and Scheduling Dependencies For Batch Jobs
  • Familiar with Oracle Tasks Like Creating and Managing Users, Roles, Grants Etc.,
  • Proficient knowledge on Tableau Desktop, Tableau Reader and Tableau Server and also experienced in taking back ups and restoration of Tableau repository.
  • Created UNIX Korn Shell Scripts For Informatica Pre - Load, Post-Load Operations For ETL Loads Like Parameter Modifications Or FTP Activities Or Multiple Conditional Workflow Kick-offs
  • Experience with Diverse Source and Target Systems like Oracle , SQL Server, DB2 UDB, Netezza, Salesforce, CSV/Flat Files, and XML Files and SharePoint Data Sources.
  • Familiar with DB Performance Oriented Pushdown Optimization and Partitioning Concepts In Informatica
  • Good Team Player with Excellent Interpersonal and Communication Skills, Technically Competent and Result - Oriented Work Attitude
  • Always Willing To Learn and Adapt, To Increase The Technical Gamut
  • Possess Microstrategy skillset as well to couple it with the Datawarehouse knowledge to gain an edge at the work efficiency and understanding

TECHNICAL SKILLS:

ETL Tools: Informatica 9. x/10.x,Informatica MDM 9.7

Reporting Tools: Microstrategy 9.4, Tableau 10.2

Languages: SQL, PL/SQL, UNIX Shell script

Databases: Oracle (10g, 11g), Netezza, Teradata

Other tools: Bladelogic, IBM Maximo, JIRA, ITSM-Remedy, Toad, Autosys, WinSCP, SSH

Systems: Windows, UNIX, MS/DOS

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Senior ETL Developer

Responsibilities:

  • Understanding Business requirements and the functionality of the existing systems.
  • Responsible for design and implementation needed for loading and updating the warehouse.
  • Responsible for implementing Re-usable Mapplets, transformations, Mappings, Email, Command tasks and Unix Scripts.
  • Responsible for implementing SCD Type-1, Type-2, Truncate/Reload and Incremental Loading mappings using Mapping Variables and Parameter Files.
  • Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level by implementing Push Down Optimization, Session level Partition, Ordering the data in Lookup/Join queries.
  • Used Designer to create source definitions, designed targets, created mappings and developed transformations.
  • Conducting unit testing.
  • Providing the post implementation support.
  • Used various Informatica transformations like Expression, Filter, Aggregator, Rank and Router to load better and consistent data into the targets.
  • Extracting the source data to feed the staging, Operational and warehouse tables using Informatica Server manager mappings

Environment: Informatica Power Center 10.1, Informatica MDM 9.7, Oracle, Netezza, UNIX, Autosys, Tibco

Confidential, Reston, VA

Lead Informatica Developer

Responsibilities:

  • Responsible for loading data from source systems like sql server, Flat files into Oracle tables using various transformation - Expression, Lookup, Source Qualifier, Update Strategy etc.
  • Applied business and application knowledge to design the data loads for consistency and integrity.
  • Worked with production load standards and error handing.
  • Assisted in performance tuning by running test sessions.
  • Created and facilitated presentations and demonstrations for Informatica.
  • Scheduled Informatica workflows using Shell Scripts. Created Tasks, Workflows and Worklets using Workflow Manager.
  • Created the transformation routines to transform and load the data. Tuned Mappings and Workflows for better performance.
  • Fine-tuned Transformations and mappings for better performance.
  • Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
  • Worked with analysts and data source systems experts to map requirements to ETL code.
  • Created the transformation routines to transform and load the data. Developed processes for automation of loading data using parameter driven sessions for batch schedule processes, verification and re-conciliation of data stored in several different source systems.
  • Experience with Teradata as the target, worked with BTEQ, FastLoad and MultiLoad
  • Tuning and performance improvement of the jobs in Informatica. Translated business requirements to Informatica Mappings. Involved in Unit testing of mappings.
  • Designed and documented validation rules, error handling routines and testing strategy for the mappings

Environment: Informatica Power Center 9.5/9.6 Oracle, Teradata, SQL/PL-SQL, Data warehouse Concepts, UNIX, Autosys

Confidential, Charlotte, NC

Lead Informatica Developer

Responsibilities:

  • Leading the project team in GDC model for data warehouse development using Informatica and Oracle and Netezza databases.
  • Interacts with business partners to gather, interpret, analyze the requirements, do the feasibility study and implement the fitting technology solutions within the boundaries defined by the LoB
  • Works with the Architects and Different Technology and Business Teams in designing the technology solutions for expanding the Warehouse with increasing data integration needs of the LoB.
  • After designing the high level Plan of the development effort, delegating the work among the team coordinating with offshore development teams to ensure efficient distribution of work efforts.
  • Worked on all power center tools to build workflows, deploy them across the environments and scheduling the data load jobs in Autosys Scheduler.
  • Implemented solutions for Data Quality and Data control by designing the Workflows in PowerCenter
  • Worked with a good understanding on data federation strategies to achieve data integration objectives of the application
  • Worked with Informatica cloud to integrate Salesforce and load the data from Salesforce to Oracle ERP systems.
  • Involved in importing the existing Powercenter workflows as Informatica Cloud Service tasks by utilizing Informatica Cloud Integration.
  • Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
  • Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate the historic data in the tables applying business logic
  • Wrote Package containing several Procedures and Functions in PL/SQL to validate before loading into Application database.
  • Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
  • Involved in Creation of tables, Partitioning tables, Join conditions, correlated subqueries, and nested queries, views for the business application development.
  • Created relevant staging tables to load data identified the business validation rules. Created SQL Loader scripts using UNIX shell scripting and PL/SQL
  • Extensively worked in creating and integrating Microstrategy reports and objects
  • Prepared test cases for subjecting the application code to necessary and effective testing
  • Performed unit testing, Integration testing and performance testing based on the need and scale of the development efforts

Environment: Informatica Power Center 9.5/9.6 Oracle, Netezza, SQL/PL-SQL, Data warehouse Concepts, UNIX, Autosys

Confidential

Lead Informatica Developer

Responsibilities:

  • Leading the project team in GDC model for data warehouse development using Informatica and Oracle database.
  • Interacts with business partners to gather, interpret, analyze the requirements, do the feasibility study and implement the fitting technology solutions within the boundaries defined by the LoB
  • Works with the Architects and Different Technology and Business Teams in designing the technology solutions for expanding the Warehouse with increasing data integration needs of the LoB.
  • Implemented solutions for Data Quality and Data control by designing the Workflows in PowerCenter
  • Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate the historic data in the tables applying business logic
  • Participated in the various upgrade & migration activities of the project ensuring the Confidential regulatory and compliance standards are met
  • Gained the SME of the application and utilized the knowledge to improvise the functionality of the application by working on enhancements in prevention of defects and resolving the production state defects
  • Prepared test cases for subjecting the application code to necessary and effective testing
  • Performed unit testing, Integration testing and performance testing based on the need and scale of the development efforts

Environment: Informatica Power Center 9.1 Oracle, SQL/PL-SQL, Data warehouse Concepts, UNIX, Autosys

Confidential

Informatica Developer

Responsibilities:

  • Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
  • Involved in the development of Informatica mappings and also tuned for better performance.
  • Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence.
  • Extensively used ETL to load data from Oracle database to Teradata database.
  • Extensively worked on client information stored in Oracle database using GUI interface.
  • Wrote stored procedures for application using PL/SQL
  • Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints. Written complex stored procedures and triggers and optimized for maximum performance.
  • Involved in creating Unix Scripts for event automation.
  • Has been involved in the testing process like Unit testing, System integrated testing
  • Has been partly involved in the UAT testing.
  • Created business/User required documents for the user understanding and involved in the code migration from Dev to QA and Prod.
  • Has given support in the Prod environment and also monitored the jobs.

Environment: Informatica 9.1 (Power Center, PowerMart, PowerExchange) Shell scripting, Oracle, PL/SQL, SQL, Linux, Erwin, Visio, Microsoft Suite, and Control-M

Hire Now