Lead/sr. Etl Developer Resume
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.