We provide IT Staff Augmentation Services!

Etl Administrator Resume

NC

SUMMARY

  • Nine (9+) years of work experience in Data Warehousing and Data integration, Data Quality and conversion processes, including Software installation, Design, Development and Administration.
  • 9 years of DataStage / Information Analyzer experience as a developer/admin.
  • Extensive experience in analysis, design, development, testing and implementation as Oracle PL/SQL and Forms/Reports Developer.
  • Hands on experience with client - server application development using Oracle 11g, 10g, 9i, 8i, PL/SQL.
  • Expertise in Writing SQL Queries and Optimizing SQL Queries.
  • Expertise in setting up CDC for Disaster Recovery environments and MDM systems.
  • Extensive experience in building Client Server Applications using Oracle, PL/SQL, Stored Procedures, Packages and Database Triggers working with partitions, creating, modifying and sizing database objects.
  • Experienced and involved with all teh stages of software development life cycle.
  • Extensive ETL experience in Installation, Configuration, Upgradation, Migration and Administration of IBM DataStage Server and Enterprise Editions and Information Analyzer (Versions - 7.x/8.0/8.1/8.5/8.7/9.1/11.3/11.5)
  • Experienced in troubleshooting DataStage jobs, fixing bugs and addressing production issues like performance tuning and enhancements.
  • Experienced in debugging Rules, Column Analysis, Exceptions and Table management in Information Analyzer versions 8.0 / 8.1/ 8.5/ 8.7/ 9.1/ 11.3/11.5
  • Experienced working with various operational sources like Teradata, SQL Server, Oracle, DB2, Flat files, Hadoop, Hive.
  • Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles, DB link and Materialize view (M-view).
  • Experience in full Software Development Life Cycle (SDLC) i.e. requirements analysis, detailed design, development, unit testing and integration.
  • Diverse noledge of data dependencies using Metadata of DataStage and running job sequences for existing jobs to facilitate scheduling of multiple jobs.
  • Good Knowledge in transferring data to mainframes using Network Data Mover (NDM)
  • Excellent noledge of RDBMS principals.
  • Experienced working on historical reload of data and data validation of data warehouses.
  • Experienced working with DataStage Version control software.
  • Migration of DataStage Projects & Jobs from previous versions of DataStage 7.5 into InfoSphere DataStage 8.0, 8.1,8.5, 8.7, 9.1, 11.3,11.5
  • Work with IBM Technical Support on resolution of complex issues, patches, software upgrades etc.
  • Promotion of Projects and Jobs between DEV, UAT and PROD servers using elevation request forms with business approvals.
  • Experienced in managing storage on various file systems and backing up data using snapshots or TSM backups.
  • Experience in various monitoring tools like Tivoli, Nmon, and solar winds.
  • Good aptitude for problem solving and logical analysis.
  • Excellent interpersonal communication skills.
  • Possesses teh ability to work effectively in a team environment or individually.
  • Self-motivated, quick learner and adaptable to any situation.
  • Multilingual, highly organized, detail-oriented professional with strong technical skills.
  • Experience with Production Support On-Call, debugging various issues for off-shore / on-shore when needed. Flexible to work in shifts.

TECHNICAL SKILLS

ETL ToolsInfo: Sphere DataStage 8.0/8.1/8.5/8.7/9.1/11.3/11.5, IBM CDC, Information Analyzer (All Versions till 11.5), Discovery, Informatica

Operating Systems: Windows (All Versions till date), Unix (Sun Solaris, AIX), Linux (Red Hat, SUSE)

Databases: Oracle 9i/10g/11g, DB2, Teradata, SQL, Oracle SQL*Plus, SQL*Loader, SQL Navigator, Toad, Oracle Designer, Hadoop, Hive.

Languages: SQL, UNIX shell programming, PL/SQL, Unix-shell scripting.

Database Tools: Oracle SQL*Plus, SQL*Loader, SQL Navigator, Toad, Oracle Designer.

Other Tools: Microsoft Office 2000/NT/XP/7, MS Visio, Unigraphics, Autocad and Minitab

Connectivity Tools: Putty, Cygwin X, Reflection, Exceed

PROFESSIONAL EXPERIENCE

Confidential, NC

ETL Administrator

Responsibilities:

  • Configured and Administered DataStage, QualityStage, ProfileStage, Information Analyzer, IS Manager and Metadata Server of InfoSphere Information Server 8.1 / 8.7/9.1.2/11.3/11.5 suite in Dev, UAT and Prod Phases.
  • Planned, configured, installed and supported IIS 11.3/11.5 Version on a grid infrastructure including Information Analyzer.
  • Successfully moved code for 90 applications consisting of thousands of jobs from version 8.1 to 11.3 and 11.5.
  • Managed a team of 8 personnel for teh development of teh database, procedures, functions, etc
  • Optimized and modified teh triggers, complex store functions, procedures, user base data type etc.
  • Responsible for dealing with various problems, bug fixing and troubleshooting
  • Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
  • Unlocked jobs. Set up Configuration Files, Job Parameters, Environment Variables and Data Connections across jobs in a project.
  • Prepared disk, file, network resources and packages. Modified kernel parameters and user limits. Resolved incompatible JRE errors during upgradation.
  • Involved in DataStage security - assigned IIS suite and suite component roles in IIS Web Console.
  • DataStage disk usage - projects, system files, datasets & scratch.
  • Installed and Configured fix pack 4 on IIS 8.1 and resolved errors.
  • Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.1 version, and recently from 8.1 to 9.1, 11.3 and 11.5
  • Worked with Administrator Client to manage projects and set their properties.
  • Worked with Director Client to schedule, run and view teh logs of jobs.
  • Worked with Designer Client to debug server, parallel and sequence jobs using stages.
  • Categorized and created new data elements.
  • Administrator for Information Analyzer profiling tool
  • Importing Metadata, creating and configuring projects, setting up data sources and establishing connectivity to teh oracle databases for various versions of IIS suite.
  • Worked on progress initiatives to teh ETL for better performance of teh GRID
  • Successfully moved code from Informatica to DataStage conversion project
  • Worked on building new production environment for Information Analyze 8.1.2 / 9.1.2/11.3/11.5
  • Installed and configured DQC for easy access / readability to exceptions for teh business users in Information Analyzer
  • Setup security roles for various applications and users on teh grid to control teh users from unnecessarily accessing information they don’t need to.
  • Successfully connected Apache Hive from DataStage and Information Analyzer using Kerberos autantication and also Cloudera from teh client machine.
  • Worked on NAS / SAN devices. Setup / mounted q-trees on NFS File systems to share across various location on a common Filer / Volume.
  • Successfully built lab servers for teh newer versions of DataStage and Information Analyzer to use them for testing various test cases and also as corp training servers.

Environment: InfoSphere DataStage 8.0/8.1/8.7/9.1/11.3/11.5 GRID (Designer, Director, Administrator), Information Analyzer 8.0/8.1/8.7/9.1/11.3/11.5, IBM CDC, Oracle, Linux, Unix

Confidential, CO

ETL Administrator

Responsibilities:

  • Involved in analysis based on requirements and developed Cluster & Grid Architecture for data integration.
  • Developed Server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Experience in database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
  • Used SQL Server SSIS tool to build high performance data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from teh XML file and loaded it into teh database.
  • Used SQL Server SSIS tool to build high performance data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from teh XML file and loaded it into teh database.
  • Selected Installation Topology with layers for teh products of Information Server.
  • Prepared disk, file and network resources. Modified kernel parameters and user limits.
  • Installed, Configured and Administered IBM IS 8.0 suite.
  • Worked with IBM to troubleshoot data integration suite issues. Resolved incompatible JRE errors during installation.
  • Added, deleted and moved projects and jobs. Purged job log files and traced server activity.
  • Issued DataStage engine commands from Administrator. Started and stopped DataStage engine and managed logs.
  • Managed DataStage services like DSRPC, Telnet and Engine Resource Services.
  • Configured NLS for WebSphere DataStage and QualityStage in dsenv file.
  • Migrated DataStage and QualityStage jobs from earlier versions to DataStage 8.0 version.
  • Worked on setting up users for IIS suite and suite components for different products.
  • Used IIS Web Console for administration areas: security, licensing, logging, and scheduling.
  • Created different type of reports like Administrative reports, IA Column Analysis reports, Metadata reports and Fast Track Mapping specification reports from IIS console.
  • Installed WAS 6.0.2.11 and DB2 9.1 metadata repository automatically and configured LDAP user registry with Microsoft Active Directory in both WAS & IIS.
  • Used Control-M to schedule jobs and e-mailed teh status of jobs to operations team daily.

Environment: DataStage 8.0/7.5.3, Windows XP, SQL 2000/2005 server, Version Control, Oracle 9i, SQL Server 2000, Shell Scripts and Unix.

Confidential

DataStage Administrator/Developer

Responsibilities:

  • Installed, Configured and Administered IIS DataStage
  • Managed shipping and handling data by profiling, designing, and loading it into teh target oracle database.
  • Configured .odbc.ini, dsenv, uvconfig, DSParams, uvodbc.config files at both engine and project levels.
  • Configured parallel engine, database connectivity in parallel environment and access to ODBC sources.
  • Started and stopped DataStage Engine, WebSphere Application Server and Information Server and managed logs.
  • Raised PMRs with IBM on upgradation problems, patches and fix packs.
  • Managed Users, Groups, active sessions, logs, schedules and licenses in IIS Web Console.
  • Worked on Oracle and DataStage Server performance tuning approaches.
  • Backed up and restored InfoSphere Information Server suite.
  • Configured NLS to support character maps and locales.
  • Managed ASBAgent, Logging Agent, DSRPC, Telnet and Engine Resource services.

Environment: Data Stage, Oracle, Linux, and Windows

Hire Now