We provide IT Staff Augmentation Services!

Etl Technical Onsite lead/lead Developer Resume

San Antonio, TexaS

SUMMARY:

  • Having 8 years of professional IT experience in design, development and implementation of various Data warehousing applications using IBM InfoSphere DataStage 11.x/9.x/8.x Enterprise Edition (Administrator, Manager, Designer, Director), Informatica Power Center 9.6, SQL Server Integration Services(SSIS) and Oracle Data Integrator Enterprise Edition.
  • Having experience on implementing the complex transformation journeys in integrating the data from dispersed source systems into common data warehouse to have it as a "single source of truth".
  • Technical expertise on data management (data warehousing, metadata, data architecture, data quality, data analysis & database development).
  • Strong Knowledge of Data warehousing(DWH) concepts, Relational Database Management Systems and Dimensional modeling (Star schema and Snowflake schema) with extensive implementation on Slowly Changing Dimensions - Type I & II in Dimension tables.
  • Expertise in building the end to end application and low level technical design for the project requirements with significant experience leading complex data warehousing projects.
  • Have the strong knowledge and experience in Oracle, DB2, Natezza, SQL Server and Teradata databases
  • Have worked on SAP Business Objects(BO) to build the reports in the business required format
  • Have worked on the IBM Information Governance Catalog(IGC) to create and manage enterprise vocabulary and information governance practices.
  • Worked extensively on different types of stages like Sequential File, Data Set, Aggregator, Transformer, Merge, Join, Modify, Lookup, Sort, Filter, Switch, Slowly changing dimension, Change Capture/Apply, XML Transformations, and Column Import/ Export.
  • Extensively used Job Activity, Wait For File Activity, Execute Command, Notification, Terminator, Sequencer activities while implementing Job Sequence with Job Dependencies, Checkpoints to restart ability.
  • Built a reusable table driven File to Table Load and Table to Table load framework which is reused across multiple projects.
  • Automated the execution of ETL jobs by using the ETL framework
  • Having expertise on converting the UDA's(SAS Code) with ETL Jobs.
  • Automated the validation of ETL standards and best practices by using the Code Quality Framework tool
  • Strong knowledge in SQL Queries, Triggers, Debugging, Troubleshooting and Performance Tuning.
  • Experience in utilizing Hadoop infrastructure for data summarization and to analyze data, data archiving by using HDFS, Hive, Sqoop, HBase and Big SQL with good understanding on Big Data concepts.
  • Technical hands-on expertise in using Oracle ESSBASE and working knowledge in writing Essbase Reporting and Calculating scripts.
  • Automated the execution process of Essbase Reporting scripts using Perl, Bat & MaxL scripts which saved lot of effort and money for the business.
  • Strong knowledge on UNIX Shell, Windows and VB Scripting.
  • Have worked in different phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing and Maintenance in Agile & Waterfall Methods
  • Ability to meet the deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good inter and intra personal communication skills with ability to quickly adapt to new environments and learn new technologies.
  • Experience in training resources on Datastage, Unix, ESSBASE, Control-M and actively coordinated with onsite business users for project implementation

TECHNICAL SKILLS:

Data warehousing Tools: IBM Datastage 11.5/9.1/8.1, Oracle Data Integrator (ODI), Informatica, SSIS & SAP BO

Languages: SQL,PL/SQL, HQL(Hive), Unix, VB, Windows and ESSBASE Reporting Scripting, SAS

Data Profiling Tool: IBM Information Analyzer(IA) & Information Governance Catalog (IGC)

Databases: Oracle10g/9i, MS SQL Server 2005/ 2008, Teradata, MS Access, IBM DB2,Netezza,HDFS

Tools: /Utilities: Control-M, SQL Developer, Putty, Squirrel, Hbase, Oozie, Big SQL, Scoop

Control Management: RTC

Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, Texas

ETL Technical Onsite Lead/Lead Developer

Tools: used: Datastage 11.5/9.1, Informatica, ODI, Hadoop, Control-M, RTC, Putty, IBM IGC and IA, SAP BO

Database: IBM DB2, Oracle, Natezza, HDFS,Teradata

Responsibilities:

  • Organizing RAC (Requirements Acceleration Sessions) and gathering Business Requirements from CFO Business SME’s and creating Enterprise Bus Matrix with necessary domain values for the required dimensions
  • Analyzed the requirements before starting the development process and providing estimation based on the complexity.
  • Worked on High level and Low level Design, Data Flow diagram, Source to Target mapping, job design documents, Data lineage and Best Practices templates for the project which were used for IBM IGC tool
  • Perform dimensional data modeling (Kimball)-star schema
  • Have taken care of all the tasks from the creation of project in DEV to production migration and validation
  • Developed job sequences with restart ability, check points and implemented proper failure actions.
  • Built reusable sequencers and parallel jobs and used the appropriate partitioning techniques for the robust performance of the jobs.
  • Have worked on all the utilities in Teradata for the better performance of the system
  • Automation of UDA (User Defined Applications) - Converted SAS code with ETL
  • Automation of Validation Reports between source systems and Financial Information Hub (Reconciliation between source and Target)
  • Drill back tables design between Staging and Processing Schema
  • Review the jobs to validate coding standards and fine tuning jobs/process for performance improvement and ensured we follow t all the COBBIT standards
  • Have setup the project in Hadoop environment and established the framework to extract the data from hive tables and FTP the files to Datastage server and also to archive the database tables data to hive tables.
  • Have setup the process to extract the archived hive tables data back to database with better partitioning techniques.
  • Built ODI Interfaces and Packages to load the data from Oracle database to ESSBASE application.
  • Built reports in the business required format by using SAP BO
  • Automated Scheduling of jobs through BMC Control-m
  • Iteration Planning and present Iteration Demos as part of Agile Execution methodology
  • Split up the tasks to offshore team and tracking the task through RTC.
  • Prepared Demo documents to showcase the effort put by the offshore team to the project management
  • Have used the IBM IGC to create glossary assets and information governance rules and also defined the relationship between assets in catalog .
  • Performed Data profiling and Analysis using IBM Infosphere Information Analyzer
  • Lead the Data Integration team of offshore (10)

Confidential, San Antonio, Texas

ETL Technical Onsite Lead/Lead Developer

Tools: used: Datastage 9.1, Informatica Power Center, People Soft, Hadoop, Control-M, RTC, Putty

Database: Oracle

Responsibilities:

  • Interacted with business users, reporting analysts in gathering information about the business logic to populate the target tables.
  • Analyzed the requirements before starting the development process
  • Worked on High level and Low level Design, Data Flow diagram, Source to Target mapping, job design documents, Data lineage and Best Practices templates for the project
  • Developed job sequences with restart ability, check points and implemented proper failure actions.
  • Built reusable UNIX scripts to FTP the multiple files from source system to ETL Server and archive the files to Hadoop server.
  • Built reusable sequencers and parallel jobs and used the appropriate partitioning techniques to give the better performance results to the jobs.
  • Developed Hadoop scripts to load data into Hive tables from Relational database
  • Review the jobs to validate coding standards and fine tuning jobs/process for performance improvement and ensured we follow all the COBBIT standards
  • Automated Scheduling of jobs through BMC Control-m
  • Iteration Planning and present Iteration Demos as part of Agile Execution methodology
  • Lead the Data Integration team of offshore (5)

Confidential

Sr ETL Developer and Module Lead

Tools: used: Datastage 8.1/9.1,Informatica, SSIS, Unix, Control-M,RTC

Database: ESSBASE, MicroSoft SQL Server 2005

Responsibilities:

  • Responsible for interacting with Onsite team for requirements gathering
  • Analyzed the requirements before starting the development process
  • Collaborated with project team members in providing design and development guidance, mentoring, best practices and used to come up with good methodology to follow uniformly across project
  • Lead the effort of extracting of data from source system ESSBASE financial cubes and quickly learnt developing the reporting scripts to extract the data from it.
  • Analyzed different programming languages like SAS Code to convert it into datastage jobs
  • Built reusable sequencers and parallel jobs and used the appropriate partitioning techniques to give the better performance results to the jobs.
  • Created the Schema file to dynamically pass the metadata in Sequential file stage.
  • Created Shared Container to encapsulate the logic that is commonly used across the project.
  • Created ESSBASE framework to run Reporting scripts from server using Perl and MaxL scripts
  • Responsible for creating so many reusable Unix scripts to use them across all LOB jobs
  • Automated the execution of job using ETL Framework and Control-M and able to debug various sorts of error in the data stage director.

Confidential

Sr ETL Developer and Module Lead

Tools: used: Datastage 8.1/9.1,SSIS,Unix,Control-M,RTC

Database: Sequential Files, MicroSoft SQL Server 2005

Responsibilities:

  • Responsible for interacting with Onsite team for requirements gathering
  • Responsible for creating the detailed design specification documents, Source to Target Mapping Documents and unit & system test plans
  • Designed and developed the jobs to extract (FTP) the files from source system in parallel and to generate the schema files for the extracted files.
  • Designed and developed the jobs to load the data from the extracted files to target tables in parallel.
  • Developed Sequencers and parallel jobs to process large volume of data and obtained the performance statistics on jobs for performance tuning purpose.
  • Responsible for creating reusable batch and VB Script for converting the xls files to csv files
  • Responsible for creating the reusable Batch and Vb scripts for generating the QC File for Quality Check after FTP of the source file from source server to Unix server
  • Responsible for developing the required Stored Procedures in SQL Server 2005
  • Involved in Creating Minutes of Meeting documents and listing out Action Items to the team.
  • System testing and Production support
  • Documented ETL test cases and validations based on design specifications for unit testing, system testing, prepared test data for testing, error handling and analysis.

Confidential

ETL Developer

Tools: used: Datastage 8.1/9.1,Unix,Control-M,RTC, SQL Developer

Database: DB2, Oracle

Responsibilities:

  • Responsible for interacting with Onsite team for requirements gathering
  • Understanding systems with respect to different Lines of Business and preparation of understanding documents.
  • Preparation Minutes of Meeting, A&D documents, Source to Target mapping and Unit & System test plan
  • Preparing Low Level Design of the Components as per the requirement.
  • ETL jobs and Scripts Development based on the Design.
  • Ensuring Reusability of Code to the other developers.
  • Involved in error handling and trouble shooting and excessively used DS Director for monitoring Job logs to resolve issues.

Confidential

ETL Developer

Tools: used: Datastage 8.1, SQL Developer, Unix

Database: Oracle

Responsibilities:

  • Coordination with on-site team to understand the requirements.
  • Preparing Low Level Design of the Components as per the requirement.
  • Preparation of Minutes of Meeting, Source to Target mapping, Wisdom, UTP and UTR documents
  • ETL jobs and Scripts Development base d on the Design.

Confidential

VB.Net Developer

Tools: used: VB.Net, VB6, Microsoft Visual Studio

Database: Oracle

Responsibilities:

  • Pre-Migration analysis of VB6 Code and converting the code from VB to .NET using the visual studio 2005
  • Coordination with on-site team to understand the requirements
  • Fixing the compilation errors and runtime errors
  • Performing Unit Testing, Integration Testing, System Testing and Production Support.
  • Preparation of Minutes of Meeting, Analysis and Design, Technical specification and business documents

Hire Now