We provide IT Staff Augmentation Services!

Sr. Datawarehouse Developer/architect Resume

5.00/5 (Submit Your Rating)

PA

SUMMARY

  • Fifteen Years hands - on experience in Software Development; architecting, analysis, design, development of data warehousing business systems wif expertise in Pharmaceuticals, Retail, E-Commerce, BFSI and Manufacturing, tourism domains.
  • Strong noledge of dimensional modeling and data warehousing best practices.
  • Ability to gather business requirements from teh Business Analysts and transform into functional requirements. Deep understanding of challenges wif data management, data acquisition, data integration and data quality architecture.
  • Creating Schemas, building logical and physical models using ERWIN.
  • Extensive experience in architecting, developing and managing full life cycle of ETL deliverables.
  • Informatica administration & upgrades. Extensive noledge in performance tuning and advanced Informatica features.
  • Hands on noledge as a senior ETL developer using Informatica tool on multiple projects.
  • Extensive noledge as BI and report developer using various tools like COGNOS, Business objects, etc.,
  • Architecting teh data warehouse solution for industries like retail, healthcare, pharma, e-commerce and food product companies.
  • Expertise in in ETL tools Informatica, Sql Server DTS/SSIS, Sagent ETL, Talend and PL/SQL, BTEQ and MLOAD scripts.
  • Hands on experience on Informatica CDC, IDQ, MDM
  • Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, Teradata, DB2, Flat files and XML, XML parsing, XML source files & UNIX.
  • Expertise in installation of Informatica, configuration, performance tuning, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into teh staging area and Design ETL processes that span multiple projects
  • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
  • Training noledge on BIG DATA - Hadoop, MapReduce, PIG, HIVE.
  • Strong experience managing team, estimation, AGILE, SCRUM process, escalation handling and handling onsite-offsite model.

TECHNICAL SKILLS

Operating System: UNIX (IBM AIX, Sun Solaris, HP UX), LINUX, Windows 2000/NT

Languages: SQL, PL/SQL, Korn Shell, BTEQ,PERL,XML

DB/Utilities: Teradata 14, Oracle 9i/10g/11g, SQL Server 2000, MS-Access, DB2, MLOAD,FASTLOAD,TPUMP,TPT

ETL Tools: Informatica 8.6/9.1,9.5,9.6

BI Tools: COGNOS, BO, TableauOracle GUI Tools Toad, ERWIN, SQL Developer, PL/SQL Navigator

Modelling Tools: ERWIN, VISIO

Documentation Tools: MS Word, MS Excel, HP ALM, VSS.

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. Datawarehouse developer/Architect

Responsibilities:

  • ETL(Informatica) and BI(COGNOS) process development for various departments like RMS, International, Inventory and Planning in AEO.
  • Working wif business requirements and will act as a business/technical analyst to identify and understand source data systems.
  • Creating and maintaining standard development life cycle documentation as part of all development project tasks.
  • Building ETL process using Informatica 9.6.1 /9.1.5 tool.
  • Estimated and designed teh ETL process based on teh requirements specifications.
  • Accessing data from various sources like relational, XML, COBOL, Unstructured data.
  • Developing medium and complex Mappings, Workflows creation
  • Promoting to production and scheduling by using teh Scripts and Control-M
  • Creating shell scripts to handling files transfer from source system and dropping teh extract to Internal partners designated file location.
  • Creating wif Informatica Data Quality (IDQ) in teh discovery and coding of cleansing, de-duping and enrichment processes used to enhance teh quality of information
  • Understand data quality requirements and recommends/develop solutions to meet those needs.
  • Analyze, troubleshoot, diagnose data quality workflow issues; recommend and implement appropriate solutions.
  • Provide high quality detailed analysis, design and build processes to support specific projects wif regard to Data Quality profiling and DQ rule coding
  • Perform data gathering, data profiling, data quality assessment, and data mapping.
  • Ensure data quality solutions are fit for purpose and deliver against business requirements.
  • Building process for data cleansing and create teh data environment for MDM.
  • Building process using teh fast Export, Multi Load utilities of Teradata.
  • Extensively wrote BTEQ scripts in Teradata
  • Adapt ETL processes to accommodate changes in source systems and new business user requirements.
  • Performance tune new/existing programs that load data into teh data warehouse.
  • Map source system data to data warehouse models, meet wif Data Modelers and DBAs to review design strategies for new ETL processes.
  • Created basic and advanced reports and dashboards usingCognos
  • Strong technical analytical skills and an ability to provide creative solutions to problems.
  • Participate in certain aspects of business user consulting, system analysis, and general system designs.

Environment: IBM Cognos 10.2.1/10.2.2 (Framework manager, Analysis Studio, Report Studio), Informatica 9.1.5/9.6.1 (Powercenter,Repository Manager, Mapping designer,Workflow Manager,etc), XML, Iseries, ERWIN, Teradata, MLOAD,BTEQ,FASTLOAD,TPT, Oracle 11g, Linux, Windows, PLSql, Shell Scripting, XML, XML parsing, XML source files.

Confidential, TN

ETL Architect - Informatica Powercenter/IDQ

Responsibilities:

  • End to end responsibility of deliverables.
  • Developed ETL processes using Informatica extract data from SAP,DB2,Oracle,SQLServer and flat files
  • Performed data analyst role to do data profiling, data mapping, data validation, data manipulation, data analysis, use case, test cases, etc.
  • Used IDQ extensively in Data Cleansing techniques
  • ImplementedIDQ dataqualityassessments and implementations includingdatadiscovery, standardization, data cleansing, address validation, matching, consolidation, bad record management
  • Working wif Business team in defining Data quality rules and coordinating wif development teams of source systems in fixing data quality issues using IDQ.
  • Interface directly wif teh customer and business owners to document functional and business requirements.
  • Articulate requirements, make recommendations for process and business flows, develop consensus on requirements, and document requirements via teh approved process and templates.
  • Creating artifacts for HLD, LLD.
  • Developed error handling based on teh data quality requirements.
  • Prepare deployment process and code migration from development to QA, QA to Production.

Environment: Informatica 9.5.1/9.1.5, Power Center, PowerExchange, Repository Manager, Mapping Designer, Workflow, IDQ, SAP R3, SQLServer 2008, 2012, Oracle 11g, TSQL, DB2, Unix, Windows.

Confidential, PA

ETL Lead

Responsibilities:

  • Worked as Onsite Lead and managed Off shore team.
  • Develop ETL process using informatica 9.6.1 to load Dimension and Fact tables.
  • Analyze teh existing PL/SQL codes and create teh mapping logics for data migration.
  • To build error handling based on teh data quality requirements.
  • Prepare deployment process and code migration from dev to QA, QA to Production.
  • Create Source to Target mappings document, design documents, configuration and support documents.
  • Maintain coding standard and reusability in teh objects created in informatica.
  • Working wif DBA to improve teh performance of teh ETL Process.

Environment: Informatica 9.6.1/9.1.5, Oracle 11g, PL/SQL, UNIX Scripts, TIBCO, UNIX, Windows, COGNOS 10.2.1, ERWIN

Confidential, FL

Sr. Informatica developer

Responsibilities:

  • Create high and low level ETL design to meet user requirements.
  • Create other ETL artifacts such as functional requirement document, design documents and deployment document etc.
  • Independently develop complex Informatica mappings, sessions and workflows as per teh design specifications.
  • Deploy and Support production ETL jobs.
  • Report development using Tableu.
  • Evaluate, determine root cause and resolve production issues.
  • Propose, implement and adhere to best practices, standards and processes.

Environment: Informatica 9.0.1/9.1.6, Oracle 11i, PLSql procedures, DB2 views, Unix Scripts, DB2, AS 400, Unix, Windows, UC4 scheduling tool, Tableau 8.1.5 reporting tool

Andersons, OH

Sr. ETL/MDM Architect - Informatica Powercenter Architect

Responsibilities:

  • Configured and maintained various components of teh MDM Hub including teh schema, landing and staging tables, configuring BaseObjects, Look-ups, Hierarchies, Queries and Query groups.
  • Utilized Informatica Data Quality (IDQ) extensively for loading teh data into Informatica MDM Hub
  • Proven experience in improving teh data quality by Match analysis, analysis of teh MDM system performance and tuning teh performance by changing teh existing cleansefunction, match rules etc.
  • Strong hands on working noledge in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Create high and low level ETL design to meet user requirements.
  • Create other ETL artifacts such as functional requirement document, data model, source-to-Client mapping, test case matrix, deployment document etc.
  • Independently develop efficient Informatica mappings, sessions and workflows as per teh design specifications.
  • Design ETL data model.
  • Conduct Knowledge Transfer sessions to share noledge wif teh team.
  • Support production ETL batch jobs.
  • Evaluate, determine root cause and resolve production issues.
  • Propose, implement and adhere to best practices, standards and processes.
  • Installing and configuring teh Informatica and supporting softwares and utilities.
  • Perform testing on connections, scripts, workflows, mappings and other scheduled activities.
  • Creating repository backup scripts and automated in Active Batch V8 scheduler.
  • Creating strategy documents, installation documents and supporting documents.

Environment: Informatica Powercenter, Informatica IDQ/IDE, Informatica MDM 9.5.1, Windows 2008 R2, MS Sql Server 2008 R2, Oracle 10g/11g, Perl, ActiveBatch V8

Confidential, PA

Technical Architect

Responsibilities:

  • Onsite Lead and managed 20 member of Off-shore team.
  • End to End responsible for project deliverables
  • Working wif users to understand their requirements in order to create Technical Design, Application Design and Component Design.
  • Estimated and designed teh ETL process
  • Developing Mappings, Workflows and scripts creation
  • Implemented CDC in teh projects
  • Designing and documenting teh High Level process flow of extracting teh data from teh Source system till loading teh data in Data warehouse.
  • Created Process and Technical Design Documents for teh mappings that is built to load teh dimensions in teh data warehouse.
  • Development and Code review
  • Worked wif testing team in all teh testing phases(ST,SIT,E2E,UAT)
  • Client interaction, status updates and meetings
  • Good Understanding in protection concepts like Fallback, Raids, and Journals
  • Worked wif Teradata 12 utilities like BTEQ, Fast Load, Multi Load and Query man.
  • Has experience on implementing business rules in BTEQ scripts.

Environment: Informatica 9.0.1, 8.6.1, PowerCenter, Repository Manager, Mapping Designer, Workflow Oracle 10g, Teradata 12, Unix shell Script, Oracle PL/SQL, Quality Center, MS Office

Confidential

Technical Architect

Responsibilities:

  • End to End responsible for project deliverables
  • Provide data to Risk Management department via reports. Teh data includes performance monitoring, risk governance in conformance wif regulatory guidance.
  • Work wifsenior business executives and key stakeholders to gather detailed business requirements around their data needs and tan plan a roadmap of project activity that generates measurable improvement in business performance metrics/Key Performance Indicators (KPIs)
  • Worked in stress testing, portfolio Asset Liability Management (ALM), mortgage banking, multi-family and commercial real estate lending, credit risk analytics or mortgage compliance
  • Working wif users to understand their requirements in order to create Technical Design, Application Design and Component Design.
  • Estimate and design teh ETL process,
  • Developing Mappings, Workflows and scripts creation
  • Technical Specification preparation
  • Used utilities of FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
  • Imported Metadata from Teradata tables.
  • Prepared BTEQ scripts to load data from Preserve area to Staging area.
  • Worked on Teradata SQL Assistant querying teh source/target tables to validate teh BTEQ scripts.
  • Involved in peer to peer reviews. Identifying Bugs and reporting defects.
  • Deployment to test environment and production environment
  • Configuration SOP document creation.
  • Post production support

Environment: IBM Information Server, IBM Datastage 8.0.1, Unix, Teradata 12, Oracle 10g, Cognos

Confidential, PA

Lead Datawarehouse Developer

Responsibilities:

  • Maintaining teh ETL environment in Sagent and developed various reports for internal and external use
  • Study teh new requirements for small/medium/big projects and reports.
  • Database feasibility analysis
  • Worked wif data modeler for schema level changes
  • Report Design, coding and Analysis.
  • Dashboard(Netacumen Reports) creation for Management to analyse teh daily business.
  • Cancel order analysis
  • Back order reports
  • Daily style selling reports.
  • Moving to objects to production and scheduling teh jobs and reports.
  • Technical manual and user manual creation

Environment: Sagent Open Studio ETL/Reporting tool, Oracle, SQL Server, Ephiphany and Omniture

We'd love your feedback!