We provide IT Staff Augmentation Services!

Resume

Lead Etl, DevelopeR

SUMMARY

  • Over 12 years of Dynamic career reflecting pioneering experience in System Analysis, design, development and implementation of Data Warehousing systems in Retail e - commerce and Health care Domains.
  • Expert level experience in Data Integration and Data Warehousing using ETL tools - IBM Infosphere Datastage(v 11.5/11.3/9.5/8.3/7 ) and INFORMATICA MDM.
  • Extensively used IBM Infosphere components like Data Replication tool(IIDR),Datastage Designer, Director, Manager and Administrator in Data Warehouse development to load data from IBM Netezza,DB2 (Z/OS), Oracle and Flat files into the target Netezza/ORACLE/DB2.
  • Experience in leading multiple teams in onsite-offshore model, result oriented and an enthusiastic team player.
  • Expertise on Datastage migration projects and played a key role in version upgrade from 7.5 to 8.5 and 9 to 11.3 both in Development and Administration.
  • Proficient in implementing Complex business rules by developing multi instance jobs, shared containers and parameter sets to increase the reusability.
  • Developed complex jobs to parse the data from XMLS by using advanced XML Hierarchical stages and Schema Library manager and extensively worked with Flat files and CSV files.
  • RDBMS experience with Oracle 10g/9i/8i, SQL Server, DB2 and PL/SQL programming.
  • Broad understanding of dimensional data modeling like Star schema, Snow flake schema, Fact and Dimension table designs through normalization techniques.
  • Strong knowledge in UNIX shell and perl scripting.
  • Excellent knowledge and experience in all stages of the Software Development Life Cycle (SDLC) and in Agile methodology.
  • Administrator experience includes Datastage InPlace version upgrades, applying IBM Fixpack patches and worked with IBM on production AIX server issues and creating Projects/users/roles, granting privileges.
  • Involved in Unit Testing, Functional Testing, Integration Testing and Regression Testing.
  • Experience in scheduling tools like Control M Enterprise Manager, Robot Scheduler, Cron tab for automating and scheduling jobs run.

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere DataStage 9.1/8.7/8.5/8.1/7.5.2/7.1/5.1 (Designer, Director, Administrator, Server manager ),

Connector Migration Tool: IBM InfoSphere Change Data Capture tool, Informatica MDM

Reporting Tool: Oracle Business Intelligence Enterprise Edition 11g( OBIEE )

Databases: Oracle, SQL Server, IBM Netezza, DB2, Teradata

Programming: UNIX Shell Scripting,PL/SQL, SQL, Perl, Java

Database Tools: Oracle SQL developer, WinSQL, Aginity,TOAD, DB2 Control Center, Teradata Studio, Advance Query Tool.

Other Tools: Control M Enterprise Job Scheduler, Robot Scheduler, Appworx scheduler, Eclipse,PVCS, SVN, GIT, Jenkins, IBM WAS, DynaTrace, Splunk, Vantage analyzer, WMQ Tool, Qpasa, Citrix

Operating Systems: Linux/Unix, Windows.

PROFESSIONAL EXPERIENCE

Confidential

Lead ETL Developer

Responsibilities:

  • Coordinate with Business Analysis and external member clients for requirements gathering.
  • Mentor other team members on the existing framework and provide in-depth technical consultation and leadership to ensure the development of efficient framework by utilizing established methodologies and best practices
  • Design and review the DataStage code and Mappings based on the ETL approach document.
  • Create architecture and technical design documents to communicate frameworks that will be implemented by the development team and how it can be leveraged for future maintenance.
  • Involved in the preparation of the Data Mapping documents for various interfaces.
  • Created various parallel jobs and sequencer jobs for automating the entire process of loading the data from source to Target.
  • Create IIDR subscriptions to capture real time changes from AS400 system and decommission traditional change data capture stages.
  • Involve in datastage migration project to convert datastage jobs from version 9.1 to 11.5 and write Unix shell scripts for server health checks.
  • Work closely with Informatica MDM developers to create stage and loading jobs to Informatica base objects.
  • Develop complex SQL queries and materialized views to optimize the batch run time.
  • Troubleshoot, performance tuning and debugging to optimize the performance of the jobs.
  • Conduct technical code reviews and suggest design changes.
  • Prepare implementation plan and create relevant supporting documents (Wiki pages) for the Production move.

Environment: IBM IIDR Tool, DataStage 11.5,PL/SQL,Shell and Perl Scripting,Java,DB2, Oracle 10g, Advanced Query Tool, JIIRA and Quality Center.

Confidential, St.Paul, MN

Sr. ETL Developer/Administrator

Responsibilities:

  • Interact with executives and business analysts to gather the reporting requirements and build the ETL jobs by incorporating the business calculations.
  • Design and review the DataStage code based on the ETL approach document.
  • Created several parallel jobs and sequencer jobs for automating the entire process of loading the data from source to Target.
  • Migration of datastage Jobs from version 9 to 11.3 and partially involved in the ver.11 environment setup.
  • Upgraded the datastage version from 11.3 to 11.5 by applying IBM fix packs and other patches by closely working with IBM through different PMR’s.
  • Have written complex SQL queries using oracle/netezza analytic functions to aggregate the business measures and load the fact tables in data warehouse.
  • Extensively used various stages like XML Hierarchical stage, Join, Transformer, Lookup, Aggregator, Funnel, Filter, Change Data Capture, Remove Duplicate, Sort, Surrogate Key, pivot, FTP, etc.
  • Developed various Unix shell scripts to invoke the datastage jobs from scheduler, backup scripts to archive datastage projects and archive scripts to perform regular space cleanup.
  • Worked on troubleshooting the production environmental issues, performance tuning and debugging to optimize the performance of the jobs.
  • Partner with other project teams to setup the new database connections by updating the ODBC and TNSORA files.
  • Worked alongside BI reporting developers and built the dashboards through OBIEE analytics

Confidential, Eagan, MN

Sr. ETL Developer

Responsibilities:

  • Involved in design phase meetings with Business Analysis for requirements gathering.
  • Design and review the DataStage code and Mappings based on the ETL approach document.
  • Conduct proof of concept to implement IIDR on high volume tables to capture real time changes and demonstrate the benefits of performance gain to management.
  • Create IIDR subscriptions to capture real time changes from AS400 system and decommission traditional change data capture stages.
  • Schedule the IIDR subscriptions either by applying mirror/refresh/park concepts wherever is applicable.
  • Developed various M ulti instance Datastage jobs, UNIX scripts and prepared schema files and configuration files for the relevant jobs.
  • Worked on troubleshooting, performance tuning and debugging to optimize the performance of the jobs and mappings.
  • Have written custom SQL queries using joins and subqueries and tuning the SQL queries to improve the performance.
  • Involved in the technical reviews and suggest design changes.

Environment: IBM CDC Tool, DataStage 9.1, PL/SQL,Shell and Perl Scripting,Java,DB2, Oracle 10g, Advanced Query Tool, JIIRA and Quality Center.

Hire Now