We provide IT Staff Augmentation Services!

Lead/sr. Etl Developer Resume

4.00/5 (Submit Your Rating)

Pittsburgh, PA

PROFESSIONAL SUMMARY

  • Eight+ years of experience in the IT industry in Banking and Finance Domain.
  • Experience in Designing, Developing, Documenting and Testing of ETL Jobs in Data Stage to populate tables in Data Warehouse and Data Marts.
  • Have experience in Waterfall Methodology as well as Agile Methodology.
  • Demonstrated experience inInformaticatools likePower Exchangefor handling data in varied environments and incorporatingreal timecapabilities,B2B Data Transformationfor transforming data into usable formats, Data Qualityfor data cleansing andData Explorerfor data profiling.
  • Well versed and experience in Design and Development of applications using Mainframe Technologies in diverse environments.
  • Well versed and experience in Design and Development of applications using ETL Tools Datastage in diverse environments. .
  • Experience in DB2 DB Database and various programming languages.
  • Exposure to Dimensional Data modellingthat includes,star schema and snowflake schema.
  • Good understanding of views, Synonyms, Indexes, Joins and Sub - Queries. Extensively used
  • Good knowledge in Analysis and Design of existing or new banking business requirements
  • Involved in ETL code migrationto Teradata from Oracle RDBMS.
  • Possess good troubleshooting and debugging skills. Flexible to adapt new environment and hardworking.
  • Self-motivated individual with strong interpersonal and problem solving skills.
  • Have a proven capacity to work on an existing and new code base, to grasp it faster and build on the same.

TECHNICAL SKILLS

Operating Systems: Windows 9x/NT/XP, IBM zOS, OS390, UNIX

Languages/ Technologies: ETL Tools (IBM Information Server V8.5, Informatica Power Center 8.6.1)

IBM Mainframe: (COBOL, JCL and VSAM)

Database/ Database Tools: DB2, Oracle, MS Excel

Special Software/ Tools: HP Quality Center, SSH Tectia.

Expediter: Debugging Tool

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Lead/Sr. ETL Developer

Responsibilities:

  • Involved in the Analysis, Design and Creation of theEnterprise Data warehouse.
  • Analysed data flow requirements and developed a scalable architecture for staging and loading data and translated business rules and functionality requirements into ETL procedures.
  • Responsible for standardizing data to store various Business Units in tables.
  • Designed and build the physical data model forODSfor Data warehouse.
  • Involved in the development ofInformaticamappingsand also tuned for better performance.
  • Documented standards handbook forInformaticacode development.
  • Developed a number ofInformaticaMappings, Mapplets and Transformations to load data fromRelational and flat file sources into the data warehouse.
  • Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, andDatabase.
  • Used RDBMS Concepts.

Environment: InformaticaPower Center V8.6.1, Toad, Oracle 10g, Teradata13.0.

Confidential

Responsibilities:

  • Backing up and restoring databases
  • Controlling andmonitoring useraccess to the database
  • Monitoring andoptimizingthe performance of the database
  • Planning forbackupand recovery of database information
  • Maintainingarchiveddata
  • Generating various reports by querying from database as per need
  • Modifying the database structure, as necessary, from information given by application developers
  • Perform database tuning and performance monitoring.

Environment: DB2 V8 for ZOS 390, Mainframe, JCL, COBOL and VSAM.

Confidential

Module Lead - Senior Technical Analyst (Datastage Developer)

Responsibilities:

  • Understand the requirement and design HLD and LLD for Datastage flows.
  • Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
  • Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
  • Developed Jobs using various Stages inData StageDesigner.
  • Discuss and ensure client standards incorporated in all designs and developments.
  • Extracted data from Complex Flat Files (CFF) and Persistent Datasets.
  • Effectively used Persistent Datasets to transfer the data between jobs.
  • Performed Unit Testing and System Integration Testing based on Test cases.
  • Created Sequencers with Error Handling, Restarting the Jobs and Trigger Email.
  • Loaded the data into DB2 UDB and Complex Flat files.
  • Used shell scripts for loading data between DB2 tables.
  • Used NDM scripts for transferring Complex Flat Files back to Mainframes.
  • Design and build CONTROL-M schedules for batch processing of datastage jobs.
  • Develop and implement strategies for performance tuning.
  • Used Sequential file,OracleEnterprise,file set, datasets, change capture, filter stagefor designing the jobs in the Data Stage Designer.
  • Used Data Stage Director for running and monitoring & scheduling the jobs.
  • Worked with Data Stage Manager for Export & Import Jobs.

Environment: ETL tool Datastage IBM Information Server V8.5, UNIX, Toad, Oracle 10g, DB2 UDB V9.

Confidential, Charlotte, NC

Module Lead - Senior Technical Analyst (Datastage Developer)

Responsibilities:

  • Understand existing Mainframes Components and design corresponding HLD and LLD for Datastage flows.
  • Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
  • Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
  • Developed Jobs using various Stages inData StageDesigner.
  • Discuss and ensure client standards incorporated in all designs and developments.
  • Extracted data from Complex Flat Files (CFF) and Persistent Datasets.
  • Effectively used Persistent Datasets to transfer the data between jobs.
  • Performed Unit Testing and System Integration Testing based on Test cases.
  • Created Sequencers with Error Handling, Restarting the Jobs and Trigger Email.
  • Loaded the data into DB2 UDB and Complex Flat files.
  • Used shell scripts for loading data between DB2 tables.
  • Used NDM scripts for transferring Complex Flat Files back to Mainframes.
  • Design and build Maestro (AUTOSYS) schedules for batch processing of datastage jobs.
  • Develop and implement strategies for performance tuning.
  • Used Sequential file,OracleEnterprise,file set, datasets, change capture, filter stagefor designing the jobs in the Data Stage Designer.
  • Used Data Stage Director for running and monitoring & scheduling the jobs.
  • Worked with Data Stage Manager for Export & Import Jobs.

Environment: ETL tool Datastage, IBM Information Server V8.5, DB2 UDB V9, UNIX, Oracle 10g.

Confidential, Charlotte, NC

Module Lead - Senior Technical Analyst (Mainframe Developer)

Responsibilities:

  • Translate business needs into technical requirements (technical analysis) to ensure all Systems support and conform to business specifications
  • Created High level & low level design documents Build Plan and Code Construction under the defined Architecture
  • Created project schedule and work break-up specification
  • Analyze the System at Unit, Integration and System Test Level and checking the completion of the analysis using TCS tool TCA (Test Coverage Analyzer).
  • Unit testing and verification by TCA
  • Coordinated project deliverables from offshore development team
  • Conduct weekly status meeting and technical training sessions
  • Provided production support for initiative releases
  • Estimation, planning and scheduling for new Initiatives
  • Delegate the tasks from functional and technical perspectives.
  • Training and mentoring of the team members based on the requirements and Developing appropriate strategies for the implementation of the project.
  • Onsite and offshore team management and Liaising/ Interacting with offshore and Onsite Management for resolving issues
  • Tracking tasks for their timely completion and Reviewing deliverables
  • Perform program construction / modification due to problem fixes and other enhancements.
  • Reporting status to the client
  • Identifying priorities in consultation with the client and changing the schedule
  • Develop and maintain Process Assets for client using the knowledge acquired in working with the Process Assets Library (PAL)
  • Collect various process and product metrics in the project and update in IRIS
  • Escalation of issues/concerns

Environment: IBM Mainframes ZOS 390, JCL, COBOL, DB2 V8 and VSAM.

Confidential

Team Member and Project Lead (Mainframe Developer)

Responsibilities

  • Preparing the Low level design document as per the High level design
  • Review program specifications for enhancements
  • Developing the Code for enhancement
  • Participation in UNIT, System Integration testing
  • Create or Modify new programs and components.
  • Prepare unit test plan and test data
  • Schedule Jobs
  • Perform bug fix
  • Support QA,CIT,SIT and test environments
  • Design and execute testing approaches
  • Ensured the quality of the deliverables made using IQMS
  • Use IPMS for all project management related quality activities

Environment: IBM Mainframes ZOS 390, JCL, COBOL, DB2 V8 and VSAM.

We'd love your feedback!