Anindya Das Email & Phone Number

Atlanta, Ga, Us

Atlanta Metropolitan Area

Atlanta, Georgia, United States

• Worked as a IDQ Solution Expert.• Co-ordinate with business users & client IT teams to analyze & understand business requirements specific to merger of 2 regional US banks.• Responsible for end to end design, development, unit testing, migration of the ETL/Informatica Data Quality (IDQ) code for Customer Information data segment.• Analyze data quality rules & reports in SAS & AbInitio platform and manually extract the business logic and review them with business IT teams.​•… Show more • Worked as a IDQ Solution Expert.• Co-ordinate with business users & client IT teams to analyze & understand business requirements specific to merger of 2 regional US banks.• Responsible for end to end design, development, unit testing, migration of the ETL/Informatica Data Quality (IDQ) code for Customer Information data segment.• Analyze data quality rules & reports in SAS & AbInitio platform and manually extract the business logic and review them with business IT teams.​• Analyze customer information data stored in Netezza database by profiling to come up with similar DQ Rules and document them.​• Develop extraction queries, IDQ mappings, rules, profiles,scorecards & other components to implement above mentioned DQ rules.​• Create DQ Scorecards, and automated reports where data stewards are able to view the various DQ Metrics.​• Enhancement of existing IDQ Rules ,Profiles, Scorecards & other components as part of remediation.​• Performance tuning of long running ETL/DQ processes & reduced the execution duration significantly. Specifically, optimized one IDQ scorecard, which ran several rules on 160M+ records & used to take 24+ hours to complete, and post optimization it completes within 1.5 hours.• Perform code reviews and other quality assurance steps as required. Show less

Sacramento, California Area

• Working as a Tech-Lead/Senior Developer.• Co-ordinate with business users & client IT teams to analyse & understand business requirements.• Responsible for end to end design, development, unit testing, migration of the ETL code for a crucial segment related to Informatica MDM Application. • Led ETL team & responsible for all ETL related deliverables ensuring timely deliveries with quality. • Development of ETL Incremental and onetime load processes using Informatica Power… Show more • Working as a Tech-Lead/Senior Developer.• Co-ordinate with business users & client IT teams to analyse & understand business requirements.• Responsible for end to end design, development, unit testing, migration of the ETL code for a crucial segment related to Informatica MDM Application. • Led ETL team & responsible for all ETL related deliverables ensuring timely deliveries with quality. • Development of ETL Incremental and onetime load processes using Informatica Power Center, which fetches relevant data from different platforms such as Teradata, MS SQL Server & Apache Impala, transforms according to various business rules, cleanses, standardizes & loads into the target. • Designing MDM Packages, MDM External Match rules for recommendation engine. • Create TSQL(PL/SQL) stored procedures, functions for realignment, matching & other processes. • Write complex SQL queries for various data discrepancy analysis. • Review and optimize the performance of SQL queries and PowerCenter jobs. • Perform code reviews and other quality assurance steps as requested. Show less

Kolkata Area, India

• Worked as Sr. ETL Developer/Offshore Lead in multiple projects for Master Data Management & Data warehouse implementations for large Insurance Clients.• Worked closely with business analysts to analyse business requirements. • Involved with architects on designing ETL data flow, data extraction rules and standardization rules. • Designed different load strategies for initial & delta loading customer data to Informatica MDM & publishing data to outbound systems including… Show more • Worked as Sr. ETL Developer/Offshore Lead in multiple projects for Master Data Management & Data warehouse implementations for large Insurance Clients.• Worked closely with business analysts to analyse business requirements. • Involved with architects on designing ETL data flow, data extraction rules and standardization rules. • Designed different load strategies for initial & delta loading customer data to Informatica MDM & publishing data to outbound systems including load using batch mode and web services. • Developed Crucial ETL delta & web service jobs to load data into target system using various industry leading ETL tools such as Informatica PowerCenter & IBM Infosphere DataStage. • Developed IDQ mappings and mapplets for implementing various data quality & standardization rules for name & address standardization. • Wrote database procedures, functions, and other DB objects in databases such as Oracle 11g, MS SQL Server etc. • Performed code reviews and other quality assurance steps as requested • Worked in reviewing and optimizing the performance of SQL queries and ETL jobs. • Code migration & QA support Show less

Kolkata Area, India

• Worked as Oracle PL/SQL Developer.• Communicating with onsite team to understand the requirement.• Analyse the requirement; create low level design documents. • Developed numerous PL/SQL packages, procedures, functions for replacing old VB based batch processes for ART Reporting, which drastically reduced overall time for generating various reports for wireless and wireline end office routing.• Developed many stored procedures which returns data set as refcursor and is… Show more • Worked as Oracle PL/SQL Developer.• Communicating with onsite team to understand the requirement.• Analyse the requirement; create low level design documents. • Developed numerous PL/SQL packages, procedures, functions for replacing old VB based batch processes for ART Reporting, which drastically reduced overall time for generating various reports for wireless and wireline end office routing.• Developed many stored procedures which returns data set as refcursor and is invoked from .Net based reporting application for generating vast number of reports.• Creating Tables, Views, M-Views, Indexes, External tables & other DB objects.• Analyse SQL performance using Explain plan, Autotrace & PL/SQL performance using profiler & optimize SQL,PL/SQL code• Unix script for scheduling• Unit Testing, Analysis & fixing issues. Show less

Kolkata Area, India

• Oracle as PL/SQL developer for this project for leading telecom giant- Vodafone • Daily staging process maintaining, data loading & validation, reporting for prepaid system data.• Writing PL/SQL procedures according to requirements.• Writing SQL queries to reconcile DWH data with prepaid systems to maintain synchronization between prepaid System Uvision, BSCS and DWH.• Providing Pro-Active and Innovative BI Deliveries to Stakeholders at ETL & IN CDR staging processing… Show more • Oracle as PL/SQL developer for this project for leading telecom giant- Vodafone • Daily staging process maintaining, data loading & validation, reporting for prepaid system data.• Writing PL/SQL procedures according to requirements.• Writing SQL queries to reconcile DWH data with prepaid systems to maintain synchronization between prepaid System Uvision, BSCS and DWH.• Providing Pro-Active and Innovative BI Deliveries to Stakeholders at ETL & IN CDR staging processing end. • Used DWH tools to deliver prepaid monthly & daily MIS Reports. Show less