Shalini Gandhi ac8oqj@r.postjobfree.com

ETL DEVELOPER (347)-(460)-0232

SUMMARY:

5+ years of IT experience in Informatica Power Center in all phases of analysis, design, development, implementation, and support of Data warehousing applications using Informatica Power Center 9.x.

Proficient using of Power Center tools (Designer, Workflow Manager, Workflow Monitor, Repository manager) and databases like Oracle, DB2, SQL Server on Windows and UNIX environments.

Experience in all the phases of life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.

Extensive professional experience in Information Technology with a strong background in the areas of ETL Design and ETL development in Data Warehousing.

Experience in Informatica Cloud Data Integration (ICDI/ICRT).

Experience on Informatica designer tools like reusable transformations, mappings, mapplets, and workflows. Extensively worked with Slowly Changing Dimensions, CDC.

Experience in Data warehouse development, working with Data migration, Data conversion.

Experience with Informatica Metadata Manager.

Worked in Production support team for maintaining the mappings, sessions, and workflows to load the data in Data warehouse.

Experience in creating detailed Documentation HLD and LLD, which includes all Business requirements and technical specifications, also created the Unit Test Plan (UTP) documents.

Experience in integration of various data sources like Oracle, DB2, Netezza, Teradata, SQL Server, MS Access and non-relational sources like VSAM, Flat files and XML files into the staging area.

Experience in designing Reusable Transformations in Informatica such as Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Proficient in Teradata Database design, implementation, and maintenance mainly in large-scale Data Warehouse Environments.

Experience in using design and management tools like Erwin and Toad, SQL Developer.

Experience in integration of various Operational Data Source (ODS) with Multiple Relational Databases like Oracle, SQL Server, and DB2 and Worked on integrating data from flat files like fixed width and delimited.

Experience in Oracle Packages, Stored Procedures, Functions, and Database Triggers using PL/SQL

Strong expertise in Understanding Logical and Physical Data Modeling, Dimensional Data Modeling - Star Schema/Snow Flake modeling, Fact and Dimension Tables.

Extensive involvement in composing UNIX shell scripts and computerization of the ETL forms utilizing UNIX shell scripting.

Knowledge in understanding Software Development Life Cycle (SDLC), requirement, analysis, design and implementation, review specification, testing and maintenance of applications in Agile Methodology and Agile Scrum meeting for creative work.

Experienced to work with Development team, Production support team and Business Analysts in handling critical situations to meet the deadlines for successful completion of the tasks/projects.

Experienced in writing and debugging to find out the problems in mappings, troubleshooting and rectifying ETL bugs.

Cognos Reports are designed, developed and deployed using the Cognos Business Intelligence solution.

Migrated Cognos reports from outdated version to latest.

Maintained the ODS for Cognos report data refresh. Implemented performance improvement best practices in report writing.

Proficient in Data Governance, Data Lifecycle, Data Quality Improvement, Master Data Management, and Metadata Management

Worked on the scheduling of reports for the users. Created, Modified the Cognos packages using framework manager.

Excellent interpersonal and communication skills, and is experienced in working with senior-level managers, business people and developers across multiple disciplines.

EDUCATION:

Master’s in Digital Science with Data Science Major, Kent State University, Ohio, USA. 4.0GPA

Bachelor’s in computer science and Engineering, Anna University, India. 8.9/10 GPA

TECHNICAL SKILLS:

ETL Tools

Informatica Power Center 10.0/9.5/9.1, SSIS, DataStage

Reporting tools

SSRS, Cognos 10

Databases

Oracle 10g/11i, DB2, Teradata, MS-SQL Server 2008, MySQL,

Netezza

OS/Environment

Windows, UNIX

Programming

SQL, PL/SQL, BTEQ, HTML, XML, Python, C#, Visual Basic, R programming

Other Tools

Toad, SQL Developer, Erwin, Viewpoint, Serena, Weka, Microsoft Word, Excel VBA.

EXPERIENCE:

Kent State University July 2018 to Current

Cognos Developer

RESPONSIBILITIES:

Experienced in Cognos 10 with Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio, and Cognos Connection.

Strong experience in creating and publishing packages in Framework Manager.

Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio.

Strong complex reporting skills – complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.

Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting, and advanced report authoring.

Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.

Interacted with Customers for requirement gathering, effective analysis and to provide end-user training.

Worked on SQL tools like TOAD to run SQL queries to validate the data.

Involved in a data migration process between different versions of Cognos.

Kent State University Jan 2018 to June 2018

Application Developer

RESPONSIBILITIES:

Resolved bugs/hotfixes of applications raised by the user using C#.

Performed Root caused Analysis for the issue and provided the optimal solution.

Enhanced features of in-house Dot Net applications and worked with web services.

Designed entities in SQL server accessed through LINQ queries.

Involved in Data profiling and administrating the database.

CVS Health Jan 2015 – Dec 2017

Teradata Developer

RESPONSIBILITIES:

Perform requirement analysis through coordination with business analysts and define business and functional specifications

As a team conducted a gap analysis and Discussions with subject matter experts to gather requirements, emphasize on problem areas and define deliverables.

Involved in the analysis of the functional requirements of the project by interacting with SME’s to design the technical specifications

Logical and Physical data modeling was done using Erwin for the data warehouse database in Star Schema.

Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (Oracle 11g, DB2, SQL server, VSAM files, and flat files) by incorporating business rules using different objects and functions that the tool supports.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.

Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

Involved in Design, analysis, Implementation, Testing, and support of ETL processes for Stage, ODS, and Mart.

Developed Reusable Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.

Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor, and Repository Manager.

Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Built real-time ODS of every 15 minutes refresh from source data using the Insert/Update process.

Reconciliation of data warehouse table data with source data.

Extensively used Autosys, Control M for Scheduling and monitoring.

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up, etc.

Extensively used various Performance tuning Techniques to improve session performance.

Created business rules in Informatica Developer and imported them to Informatica Power center to load the standardized and proper format of data to staging tables.

Worked in Error Handling using ET, UV, WT tables.

Used Teradata utilities like Fast Load, Multiload, Fast Export, T-SQL, and BTEQ.

Developed and implemented the UNIX shell scripts for file processing and command session.

Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.

Designed and Created data cleansing, validation and loading scripts for warehouse using Informatica Power Center 9.1.1/8.6.

Best Buy Aug 2013- Jan 2015

ETL Developer

RESPONSIBILITIES:

Involved in data migration from Enterprise Data warehouse to parallel data warehouse platform.

Transformed Informatica mappings to Packages in SSIS.

Built the Microsoft SQL database schema and entities as in Data Model.

Analyze the data from different sources and define the Data Warehouse/ ETL process accordingly.

Business requirements are analyzed and documented the High-level design with technical specifications.

Provided on-call support regarding production deployment.

Created SSIS package to load data from Flat File (2GB -- 4GB) to Flat File and Flat File to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, Slowly Changing Dimension.

Used custom .NET assemblies for Script Task in SSIS.

Implemented best code practices to ensure standardization and code readability.

Determined to learn with a practical approach.

Created Test Plan, Test case, Test Data and presented test results to clients for sign off.

Data quality checks on landing database are automated with SSIS package.

Contact this candidate