Etl Datastage Consultant/ Production Support Resume
KY
SUMMARY:
- 9 years of IT experience in all project phases (SDLC) including planning, design and development, testing, production support and maintenance.
- ETL developer and Production Support Analyst IBM DataStage (Designer, Manager, Administrator 11.3/8.7/7.5 ) and Quality stage, Information Analyzer, Information Governance Catalog (Formerly Business Glossary for projects including Data conversion, Data migration, Data integration, Data warehousing (EDW) and Datamart reporting.
- Experience with Data warehouse development, extraction, transformation, web services, data cleansing (Quality stage), data analysis, data validation, Post production support(On Call 24 7) identify , track defect and provide resolution/fixes in involving scheduling tools such as Control M, Autosys etc
- Experience with tuning DataStage jobs using various techniques by understanding its complexion during volume testing before moving to production. This included tuning SQL in database levels, creating table indexes, breaking big jobs into smaller units, code reusability by designing shared containers etc.
- Experience in developing Extract Transform Load (ETL) process including direct loads, incremental loads, SCD (slowly changing dimensions) loads, Views, Triggers and SQL Stored Procedures.
- Extensive experience in designing DataStage server and parallel jobs, data profiling, UNIX Shell scripting and SQL/PL SQL development.
- Strong knowledge and experience in SDLC methodologies including Agile, Waterfall etc.
- Extensive experience in implementation of Star, Snowflake schemas and multi - dimensional modeling
- Ability to interact with business users, reporting team to coordinate work, gather requirements and design work plan. Experienced in leading offshore development team and working in a offshore - onshore model.
- Experience with implementing IBM Change Data Capture (CDC) solution.
- Extensive experience in DataStage/Quality stage development projects for data cleansing, data standardization (Name and Address standardization, US postal address verification, Geo coding etc.).
- Proficient in using most of the DS/QS stages and working with Oracle, Sql-Server,Nettezza,DB2 databases
- Experienced in unit testing (during job designs), end to end ETL module testing, volume testing designing SQL test cases etc.
- Troubleshoot issues related job failures or defects, resolve by change management and any tuning necessary.
- Experience in working with Data Modelling, Business teams and PMs to address issues relating to load process, data constraints and data integrity issues. Working on Load order of Relational tables and define, design Code and Crosswalk tables as needed
- Experience in Code promotion in various environments by import, export of job designs, parameter manipulation, version control etc.
- Experienced in creating Data Warehousing and conversion projects Test Plans, Test Strategies, and Test Cases ensuring the data in Data warehouse meets the business requirements.
- Highly proficient in interacting with business users to identify information needs and initiating process changes, gathering requirements, Designing workflow using MS Visio.
- Strong communication and client/customer facing skills
TECHNICAL SKILLS:
ETL Tools: DataStage Quality stage 11.x/8.x Administrator, Designer, SSIS
Workflow: MS-Visio, MS-Access, MS Excel
Methodologies: Waterfall, Agile/SCRUMOperating Systems Windows, SUN Solaris 8/9/1, HP-UX 10.x/11.x and IBM AIX 4.0.Unix
Databases: DB2, Oracle /8i/9i, SQL Server, Teradata, Netezza
Languages: PL/SQL, SQL
CRM: Salesforce
Database Tools: SQL* Plus, SQL * Loader, TOAD, Control CenterReporting Tools Hyperion, Business Objects 6.5, SSRS, Cognos 8
Scheduling Tools: Control M, Autosys
PROFESSIONAL EXPERIENCE:
Confidential, KY
ETL Datastage Consultant/ Production Support
Responsibilities:
- Worked with business users to gather requirements for data conversion activities, design and development using DataStage 8.7/11.3. Fast-track, Information Analyzer, Quality stage and IBM CDC
- Provide on call 24/7 production support by identifying defects, documenting, resolving the issues and working with Change Management, DBA and other teams to come up with fixes.
- Involved in design and development of ETL processes for data warehousing and data integration and creating on Low level and High level technical design documentation.
- Coordinating with architects, business users, DBAs to resolve any resolve any issues related to data mismatches, integrity constraints, load orders and creating mapping documents.
- Extensively worked in Quality stage projects for data cleansing, Address verification, data investigation, Name and Address standardization, CASS certified address processing
- Job migrations from 8.7 to 11.3.
- Worked on the CDC Tool and CDC within the Information Server Platform
- Design jobs to load data into staging, intermediate and targets in data warehouses and marts by using direct loads, incremental loads, Type 2 SCD and UNIX Shell scripts as necessary.
- Develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and enforcing data Integrity and business rules
- Automated loads by designing job sequencers, creating shell scripts and scheduling the loads as required.
- Troubleshoot production issues with job log review, making necessary changes in design if necessary via change management and code promotion process.
- Developed, Scheduled IA reports using rule sets, SQL and ETL based repots.
- Tuned DataStage jobs for performance by working with DBA and SQL coding, design changes within the job
- Created stored procedures, Triggers and SQL based reports depending on requirements, Analyzed the existing ETL process and came up with an ETL design document that listed the jobs to load, the logic to load and the frequency of load of all the tables.
Environment: Unix, Oracle 11 g, DB2, SQL Server, IBM IIS DataStage 11.3/8.7 version, Information Analyzer, SSIS,SSRS FastTrack, SQL Developer, SharePoint, Microsoft Office
Confidential, Denver, CO
Senior ETL DataStage Developer
Responsibilities:
- Worked in a team with ETL developers and process analyst in preparing the requirements and writing workflows and process flows.
- Worked as an ETL developer and assisted SA‘s during Data Mapping, Data Integration, Process Mapping and Process Integration and Production support.
- Performed extensive data manipulations using various stages and coded as per the mappings between sources and targets
- Develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and enforcing data Integrity and Business Rules
- Wrote complex SQL queries to facilitate the supply of data to other teams,
- Automated loads by designing job sequencers, creating shell scripts and scheduling the loads as required
- Converting data from various applications to SalesForce target for claims systems
- Tuned DataStage jobs by breaking single job into multiple jobs, tuning SQL queries in database level and within DataStage as required and provided Support 24/7 for Datastage/BI environment.
Environment: Unix, Oracle 10, DB2, SQL Server, IBM IIS DataStage 8.7 version, Teradata, SQL Developer, Autosys, Salesforce
Confidential, Colorado Springs, CO
Senior ETL/ DW Consultant
Responsibilities:
- Developed processes for cleansing, transforming, extracting, integrating and loading data using DataStage and Quality Stage.
- Worked with Quality Stage for data cleansing (address standardization etc.)
- Developed and implemented data naming conventions and documentation for enterprise system
- Worked on Migrations and job automations by creating job sequencers and Unix scripts
- Validated data to ensure the quality, validity and accuracy of content
- Designed the mappings between sources and targets and developed ETL jobs
Environment: IBM DataStage 8 UNIX, Oracle 10, DB2, SQL Server, TOAD, SharePoint, SQL Developer, MS Office, Microstrategy, Control M
Confidential, Colorado Springs, Colorado
ETL/ DW Consultant/ Production Support
Responsibilities:
- Tuned DataStage jobs for performance by working with DBA and SQL coding within the job
- 24 X 7 On call production support on rotation basis for supporting ETL jobs
- Worked with quality stage for data cleansing (address standardization etc.)
- Working on target databases for BI /ETL reporting needs
- Worked with batch operations to do control M changes in order to schedule DataStage jobs as per requirements
- Data analysis of the various source databases and data manipulation for the data warehouse and data marts
- Enforced data Integrity and Business Rules during design of DataStage jobs
- Worked with Architects, DBA’s and other business teams to plan and implement data integration.
Environment: IBM Data Stage 7.5/8, AS400 System, Windows 2000/XP, SQL Server Oracle 9i 10g, Business Objects, UNIX, Autosys, Citrix
Confidential, Dallas, TX
ETL Data warehouse Consultant
Responsibilities:
- Worked in a team with ETL developers and process analyst in preparing the requirements and writing workflows and process flows.
- Assisted the ETL department during Data Mapping, Data Integration, Process Mapping and Process Integration.
- Performed data analysis and extensive data manipulations using various stages
- Worked on various loads in the mart including Direct, Incremental with necessary transformations
Environment: IBM Data Stage 7.5.5, SQL SERVER DB2, MS Office, Windows 2000/XP, Oracle 9i 10g, Business Objects, UNIX
Confidential, Kansas City MO
ETL/ BI Consultant
Responsibilities:
- Designed the mappings between sources and Operational staging targets.
- Used the ETL tools to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
- 24 X 7 On call production support on rotation basis for supporting ETL jobs
- Worked with DataStage/ QualityStage for data cleansing (match, address standardization etc.)
- Data analysis of the various source databases and data manipulation for the data warehouse and data marts