Over * Years of overall experience in Information Technology.
More than 6 Years of experience in working with in Data warehouses and using Informatica
Power Center 8.1, 8.6, 9.6, 10.2(Designer, Repository Manager, Workflow Manager, Workflow Monitor).
Expertise in ETL Loading strategy for slowly changing dimensions type 1 and type 2 to maintain the
history of records, Incremental load using parameters, variables, and parameter files.
Extensive knowledge with star schema, fact and dimension tables.
Expertise in configuration, performance tuning, and installation of Informatica & in integration of various data sources like Oracle, MS SQL Server, XML and Flat files.
7 Years of extensive experience with databases (MS SQL Server 2005/2008/2013, Oracle 8i/9i/10g/11g, Teradata).
Experience in using Automation Scheduling tools like Appworx, Tivoli job scheduler and stone branch.
Extensive work with PL/SQL, performance tuning of Oracle using SQL plan, SQL hints, Oracle partitioning, various indexes and join types.
Understanding and working knowledge of Change Data Capture (CDC).
Experienced in tuning Informatica mappings to identify and remove processing bottlenecks.
Experience in working with COBOL files, XML, Flat Files.
Experience in UNIX shell scripting. Hands on exposure on UNIX environment and experience in using third party scheduling tools like AutoSys.
Having experience of data modeling using ERWIN.
Experience in building of operational data stores (ODS), data marts and enterprise data warehouses.
Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
Performed Informatica upgrade from Versions 8X to 9.X.
Creation and maintenance of Informatica users and privileges. Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
Worked extensively on Ref Cursor, External Tables and Collections.
Expertise in Dynamic SQL, Collections and Exception handling.
Expedite in writing UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
Developed UNIX scripts for dynamic generation of Files & for FTP/SFTP transmission.
Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
Extensively giving mock-ups to the Enterprise user to better understand the reporting analysis and also making their life easier.
Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.
Worked in designing and implementing Data Mart and Data Warehouse applications using Erwin in Data modeling.
Involved in identification of Facts, Measures, Dimensions and hierarchies for OLAP models.
Experience in Performance tuning at sources, mappings and target level and tuning the SQL queries.
Proficient in Test execution and Bug tracking.
Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
Reliable, proactive, responsible, hardworking and good team player.
Informatica Power Center 10.2/9.5/9.1/8.6
SQL, PL/SQL, UNIX shell scripting, Java, HTML, XML, C
Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008
Cursors, Stored Procedures, Functions, Views, Triggers, Packages
Data Modeling Logical/Physical, Star/Snowflake Schema, FACT &
Dimension Tables, ETL, OLAP
Toad, Erwin, MS Project, JIRA, MS Visio, TWS, Stone branch
Signify Health, Dallas, TX
Sr. Business Intelligence Developer Jul'18- Till date
Description: Signify Health partners with health plans, healthcare providers, and other medical companies to deliver care and essential services, especially to vulnerable populations. With an innovative technology platform, unique data set, and a national clinical network, the company provides tech-enabled care services to people within the routine of their daily lives to improve health and quality of life.
Understand the Functional Business processes and Requirements from business.
Involved in Analysis, Requirements Gathering and Documenting Functional and Technical specifications.
Worked with various teams in Agile environment.
Processing data stored in various file formats like Json, Xml, Csv, txt, tsv etc.
Storing the processed output into SQL Server tables from where it can be consumed by downstream application.
Developed complex mappings in Informatica Power Center to load the data from various sources like table, flat files, webservices and ftp pull using transformations.
Implemented performance tuning on mappings to provide maximum efficiency and performance. In one case increased performance by 65% of data load by replacing sequence generator transformation with reusable expression.
Developed parameterized mappings, reusable expressions and user defined functions for increased re-usability.
Created complex mappings involving Update Strategy, Lookup, Filter, SQL, HTTP, Joiner and Aggregate
Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta loads.
Designed complex workflows with decision task, assignment task, event wait, and event raise tasks, control tasks. Scheduled workflows using Informatica scheduler and PMCMD command.
Participated in the Integration testing and Unit Testing using validation scripts.
Involved in migration of SSIS and SQL queries to Informatica Power Center.
Involved in production support and root cause analysis.
Wrote windows batch scripts to get files from external servers.
Performed migration of ETL Code from Development repository to integration testing repository and also responsible for preparing & releasing ETL builds using XL Deploy tool.
Involved in System Integration Testing, User Acceptance Testing and implementation of code to production.
Developed Mapplets using corresponding source, targets and transformations.
Used debugger to test the mapping and fixed bugs. Created and used Debugger sessions to debug sessions and created breakpoints for better analysis of mappings.
Extensively worked on Informatica IDE/IDQ. Extensively used transformations like standardizer, match, parser, labeler and SQL, profiles and scorecards in IDQ developer and Analyst.
Scheduling the Informatica workflows using Control-M,Tivoli scheduling tools & trouble shooting the Informatica workflows.
Analyzed and created the Assessment reports for Informatica Upgrade project from v9.6 to 10.2.
Created mappings, profiles and scorecards in IDQ Developer and Analyst as per requirements
Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging
Worked on IDQ file configuration at user’s machines and resolved the issues.
Designed various approaches like CDC (Change data capture), Auditing control, Recovery strategy, Scheduling jobs etc.
Environment: Informatica Power Center 10.X/9.X), Toad, Oracle SQL Developer, SQL Server Management Studio (SSMS), JIRA, Service Now, GIT HUB, XLDeploy.
T-Mobile, Bothell WA
Lead Informatica / ETL Developer Mar'17 - Jun'18
Description: Commission is one of the T-Mobile (T-Mobile is a Telecom Giant offering various devices plans to the customers throughout the Globe. Their main business is mobile networking throughout the world. T-Mobile is the third largest networking company in US) project which receives data from various sources like Dealers, Vendors, Direct and Indirect partners, employees etc. and sort it thru Commissionable, Non-Commissionable and load it into VARICENT. There are many compensation parameters which apply to calculate the commissions. It distributes the Commissions among the recipients and then generates Commissions detailed Report.
Involved in identifying dimensions and facts to create enterprise data warehouse and model.
Worked in a term for supporting and introducing Informatica into SDLC project development environment at Tufts.
Converted the already existing PL/SQL extracts and procedures to Informatica.
Built new logic and designs in mapping to help work the existing PL/SQL logic and rebuilt the entire process model in Informatica.
Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS).
Created deployment groups to easily deploy code into Testing and Production Environments.
Developed complex procedures, functions, packages, triggers, snapshots.
Worked on Change Data Capture (CDC) to simplify ETL process.
Created medium to complex PL/SQL stored procedures for integration with Informatica using Oracle 11g.
Created mappings using various transformations like update strategy, lookup, stored procedure, router, filter, SQL, sequence generator, joiner, aggregate and expression transformations in extracting data in compliance with the business logic developed.
Developed complex mappings also involving SCD Type-I, Type-II and Type-III mappings in Informatica to load the data from various sources.
Built mappings using Informatica Data Quality and export them as Mapplet to Informatica Power Center to read JSON format files.
Created various workflows to read .JSON files and loaded into staging tables and then to respective Dimension and Fact tables.
Work closely with the teams to ensure architectural integrity related to integrations activities.
Collaborate with business stakeholders for UAT and Quality Assurance for unit/technical testing.
Worked extensively in testing and performance tuning of the mapping and logic. Created and worked on the unit test cases using TOAD.
Proficiency in Teradata utilities like BTEQ, fLoad and mLoad.
Scheduled mappings and workflows using Appworx.
Used Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server.
Environment: Informatica Power Center 9.6.1, Informatica Data Quality (IDQ) 9.6, Flat Files, Oracle 11G, Quest Toad Central, SQL Server 2012, Autosys
EQT Corporation, Pittsburgh, PA
Informatica PowerCenter Developer Nov'14 - Feb'17
Description: EQT Corporation is an integrated energy company, supplying natural gas, crude oil, and gas related services to the customers. The main objective of the project was to help the decision making team of the organization, to monitor/improve the sales and to explore avenues for new business opportunities. DW team is responsible for building Global Data Warehouse and providing reports for Production and Midstream groups.
Involved in understanding and documenting the requirements of Business Analysts and Corporate Managers.
Experienced all the phases of project life cycle involving Requirement Analysis, Design, Functionality, development, Testing.
Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
Studied the existing OLTP system(s) and created facts, dimensions and start schema representation for the data mart.
Developed Informatica mappings, transformation, reusable objects by using mapping designer and transformation developer and Mapplet designer in Informatica Power Center.
Created reusable transformations and Mapplets and used them in mappings.
Worked closely with MDM team to identify the data requirements for their landing tables and designed IDQ process accordingly.
Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
Created complex mappings involving Update Strategy, Lookup, Filter, Sequence Generator, Joiner and Aggregate.
Effectively used Informatica parameter and variables in mappings.
Imported the extraction map in PowerCenter to be the source for CDC.
Worked with Informatica Change Data Capture (CDC) to recognize all the updates, deletes and inserts instantly.
Data Profiling/Data Analysis for the new clients. Continuously interact with other project team members and will interface with user departments to clarify requirement, identify and resolve problems, and ensure that user requirements are met
Extensively used SQL Loader, external tables and SSIS to load data from external files into the database.
Involved with team members of MDM to manage company’s data. Using Informatica Loaded data into the hub from different source system across the organization, after cleansing it so that a Hub can act as single source for organization.
Did QA of ETL processes, migrated Informatica objects from development to QA and production using deployment groups.
Performed Performance tuning of targets, sources, mappings and session.
Co-ordinated with the off-shore teams and mentored junior developers.
Involved in Performance Tuning of mappings in Informatica.
Created Test cases for Integration testing and UAT. Reviewed UAT with business users.
Provided on-call support for the project after migration.
Environment: Informatica 9x, Informatica Data Quality (IDQ) 9.6, Teradata 12.0/13.0, Sql Server 2008, SQL Loader, UNIX, Shell script, Toad, PVCS, Visio, Autosys.
WellPoint Insurance, Richmond VA
ETL Developer Feb'13 - Oct'14
Description: WellPoint Inc. is one of the largest Health benefits companies in the United States. The company
delivers a number of leading health benefits solutions through a broad portfolio of integrated health care plan and related services along with the a wide range of specialty product such as life and disability Insurance benefits, dental vision etc.
Managing the team day-to-day planning and problem solving to meet deliverables and acted as Single Point of Contact in running business applications.
Assisted architect to drive some key projects and helping define the roadmaps and BI strategy.
Provide periodic updates to the Business and Analysts on showstoppers to ensure appropriate actions are taken.
Interacting with Business unit to understand the business requirements and provide the possible solutions.
Develop, design specifications for data integration & to populate Data warehouse database and data analysis.
Design, develop, test, deploy and manage the data integration BI systems.
Experience in complex transformations like Transaction Control, Java transformation, Unconnected Stored Procedures, SQL, Normalizer, Update Strategy, Joiner and Aggregate of test plans for loading the data successfully into the target tables.
Address performance issues requiring in ETL system and SQL tuning.
Hands on experience in Teradata utilities like BTEQ, mLoad and fLoad.
Worked Extensively on Informatica PowerCenter with transformations like Lookup, Update Strategy, Router, Aggregator, Filter, Expression, and Union.
Experience in working on change requests which includes creating changes (Data Repair, Low Impact, Major and Minor Change requests), implementing the Changes.
Extensively used Informatica to load data from SQL Server and flat files into staging area.
Developed Shell Scripts for triggering Informatica Workflows using PMCMD Command.
Worked in Scheduling daily, weekly and Monthly jobs using Control M to extract information from multiple data sources and provide Target Files to Business Users.
As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions.
Worked Extensively on Creating and implementing Changes into Production.
Environment: Informatica 9x, Informatica IDQ, Informatica Metadata Manager, Oracle 11g and Windows 2010 professional, SQL Server 2008, ESP scheduler
Grameen Phone LTD, Dhaka, Bangladesh
Informatica Developer May'11 to Jan'13
Description: GE Consumer Finance Ltd which is now known as GE Money is a leading consumer finance company offering a range of services including personal loans, car loans, credit cards, personal insurance, and interest-free and promotional retail finance. I have worked on various projects for GE Consumer Finance ltd like Score Card Behaviors, Capital Allocation, Conversion model and enhancement on ETL Processes which helps business users in forecasting, campaigning and launching new schemes/products and promotions, discounts and offers etc. I have played a various roles and responsibilities in all these projects.
Involved in design and development of data warehouse environment based on Business Requirement.
Developed Mappings using different transformations in Power Center designer and mapping them with session and workflow in order to follow proper sequence.
Preparing the test cases for testing the reliability and functionality of the application.
Create reusable transformations and mapplets to use in multiple mappings
Involved in Migration of ETL Code between DEV, QA environment and involved in scheduling and creation of job sequence.
Implemented Level based Dimensional Hierarchy, since the information needs to be drilled based on the Business Unit Level.
Provided technical assistance and support to IT analysts and business community.
Responsible for the code deployment in Production after getting signoff from Users.
Used caching optimization techniques in Aggregator, Lookup and Joiner transformation.
Created reusable transformations and used in various mappings.
Used various debugging techniques to debug the mappings.
Developed mapping to implement type 2 slowly changing dimensions.
Developed Informatica parameter files to filter the daily source data.
Used various Indexing techniques to improve the query performance.
Creating Test Documents for Unit Test and Integration Test to check the data quality.
Environment: Informatica 8.3, IBM Mainframes, DB2UDB, flat files, UNIX, Windows 2000, Oracle 10g, SQL Server, TSQL, WinSQL, Mercury Quality Center.
Education: Bachelor's from Bangladesh, 2012