Sr. Datawarehouse Developer/architect Resume
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