We provide IT Staff Augmentation Services!

Sr. Etl Developer / Technical Lead Resume

SUMMARY

  • 15+ years of experience in Data warehousing Design, Development, Testing, Maintenance, Enhancement and Production Support environments.
  • Extensive experience in all phases of software development life cycle including Requirements gathering and Analysis, Design, Development, Testing, Deployment,Implementation and Production support.
  • Strong working experience on DSS (Decision Support Systems) applications.
  • Expertise in Informatica PowerCenter, Oracle, Teradata, PL/SQL, shell scripting.
  • Experienced in managing the team both Confidential Onsite and Offshore as Technical Lead and Solution Architect.
  • Extensive experience in ETL design, development and maintenance using Informatica Power Center 7.x/8.x/9.x/10.x, Oracle, Teradata, SQL, PL/SQL, SQL Loader.
  • Experience in Informatica Administration; experience in domain, repository version upgrdes, new Installtion, Deployment Activities; Repository maintenance - backup /restore.
  • Experience in RDBMS systesms, conceptual/logical/physical data models, Dimensional/Star/SnowFlake Schemas and Slowly Changing Dimensions.
  • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
  • Extensive experience in Production environment.
  • Experience in Unix Shell scripting.
  • Experience in performance tuning of Informatica Sources, Targets, Mappings, Transformations & Sessions.
  • Experience in Value addtions and Optimization of production jobs.
  • Expertise in Planning and Testing in various phases including Unit, Assesmbly, System Testing and Performance /Load Testing.
  • Experience in integration of various data sources like Teradata, Oracle, and DB2, Flat Files, XL files, etc.,.
  • Extensive Experience with Teradata Utilities FastExport, FastLoad and Mload.
  • Worked extensively with complex mappings using Expressions, Joiners, Routers, Lookups, and Update strategy, Source Qualifiers, Aggregators to develop and load data in to different target types.
  • Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica Power Center.
  • Experience in programming with PL/SQL.
  • Experience in Sales Ordering System - CRM & OMS
  • Experience in management activity - preparation of Estimation & Schedule, Metrics and SQA processes
  • Experience in Dimensional Modeling tool ERWIN and reporting tools COGNOS and Business Objects.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter, Informatica IDQ,DataStage, Oracle Data Integrator

Business Intelligence Tools: Business Objects,Cognos, MicroStrategy

Languages: SQL, PL/SQL, SQL*Plus, C, C++, Java,Scala,Python, UNIX Shell scripting.

Databases: Teradata, DB2, Oracle 11g/10g/9.i/8.i

Utilities/Tools: Cassandra,Vertica, SQL Server,Toad, Teradata SQL Assistant, SQL* Loader, PL/SQL, Core FTP,Erwin,Oracle SQL Developer,Quality Center, Teradata Utilities - Fload,Mload,FastExport

Operating Systems: Windows 98/2000/NT/XP, AIX, SUN OS, RHEL

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer / Technical Lead

Responsibilities:

  • Prepared Impact Analysis, Understanding Documents.
  • Prepared Estimates for CR’s and WR’s.
  • Prepared Desing Documents, User Strories.
  • Design and Development of Informatica mappings, sessions and workflows, stored procedures, shell scripts, etc.,
  • Worked on performance improvement and query tuning.
  • Woked on Informatica Administration, upgrades, maintenance, deployments, user creation, access controls
  • Conducted reviews for development and testing.
  • Production Support overview: Execution, monitoring the production jobs, backup maintenance, data validations, client communication on production cycles, issues, delays, adhoc fixes etc.,
  • Identified Optimizations and Value Adds in the project and development and oversight.
  • Onsite - offshore co-ordination.

Confidentia

Sr. ETL Developer / Technical Lead

Responsibilities:

  • Prepared Impact Analysis / Understanding Documents.
  • Prepared Estimates for CR’s and WR’s.
  • Prepared HLD (High Level Design Documents) and DD ( Detailed Design Documents ).
  • Coding: Creating mappings, sessions, worklets and workflows, writing shell scripts.
  • Testing: Writing Unit and Integration Test Plans, Conducting Unit and Integration Testing.
  • Code Review: reviewing the code developed by other team members.
  • Production Support:Running, monitoring the production jobs, backup maintenance, data validations, communicating with clients regarding production cycles, issues, delays, adhoc fixes etc.,
  • Contributing in Optimizations and Value Adds in the project .
  • Onsite - offshore co-ordination.

Confidential

Technical Lead

Responsibilities:

  • Attending Business Requirements meetings.
  • Preparing Impact Analysis / Understanding Documents.
  • Preparing HLD (High Level Design Documents) and DD ( Detailed Design Documents ).
  • Informatica Coding: Creating mappings, sessions, worklets and workflows.
  • PL/SQL: creating Functions,Procedures and Packages.
  • Testing: Writing Unit and Integration Test Plans, Conducting Unit and Integration Testing.
  • Code Review: reviewing the code developed by other team members.
  • Supporting UAT and System Test.
  • Production, Lab cycle support, on failure cycle recovery, data validations.
  • Creating Build Trun Over documents.
  • System Test, Lab and Production deployment validations.
  • Perform as on-site co-ordinator when Confidential onsite and as Development lead Confidential offshore
  • Contributing in Optimizations and Value Adds in the project .

Confidential

Technical Lead

Responsibilities:

  • Attending Business Requirements meetings.
  • Preparing Impact Analysis / Understanding Documents.
  • Preparing HLD (High Level Design Documents) and DD ( Detailed Design Documents ).
  • Informatica Coding: Creating mappings, sessions, worklets and workflows.
  • PL/SQL: creating Functions,Procedures and Packages.
  • Testing: Writing Unit and Integration Test Plans, Conducting Unit and Integration Testing.
  • Code Review: reviewing the code developed by other team members.
  • Supporting UAT and System Test.
  • Production, Lab cycle support, on failure cycle recovery, data validations.
  • Creating Build Trun Over documents.
  • System Test, Lab and Production deployment validations.
  • Perform as on-site co-ordinator when Confidential onsite and as Development lead Confidential offhsore
  • Contributing in Optimizations and Value Adds in the project .

Confidential

ETL Developer

Responsibilities:

  • Preparing Detailed Design.
  • Coding: Creating mappings, sessions, worklets and workflows using Informatica.
  • Testing: Writing Unit and Integration Test Plans, Conducting Unit and Integration Testing.
  • Code Review: reviewed the code developed by other team members.
  • Production Support:Run, monitor the production jobs, backup maintenance, data validations, communicating with clients regarding production cycles.
  • Contributing in Optimizations and Value Adds in the project .

Confidential

ETL Developer

Responsibilities:

  • Preparing Detailed Design.
  • Coding: Creating mappings, sessions, worklets and workflows using Informatica.
  • Testing: Writing Unit and Integration Test Plans, Conducting Unit and Integration Testing.
  • Code Review: reviewed the code developed by other team members.
  • Production Support:Run, monitor the production jobs, backup maintenance, data validations, communicating with clients regarding production cycles.
  • Contributing in Optimizations and Value Adds in the project .

Hire Now