Pragna K. Email & Phone Number

Chicago, Illinois, United States

Oak Brook, Il

• Involve in gathering business requirements and work closely with various Applications and Business/Client teams to document the requirements & create the design as per the business requirents for Architecture review• Participate in architecture, code development and code reviews• Apply knowledge of Big Data technologies (Hadoop Eco system, Spark, Talend, AWS) to help deliver Analytic projects.• Develop and deploy Data integration jobs in AWS using Talend• Implement Big data development best practices• Assist in configuring Big Data solutions to meet client requirements• Work on Extracting and Transforming data from different flat files, MS Excel, MS Access, XML files, JSON files and Parquet files based on business requirement using Talend Data Integration and Talend Big Data and loaded data into the target systems in order to create a datalake/Data warehouse and scheduled these Talend jobs in Talend administration Console (TAC) • Develope complex Talend Big data jobs to migrate the data from Teradata database to Amazon Redshift. • Extensively work on Talend Spark to extract the data from complex XML and load into a CSV file on s3 so it can be queried for data discovery using Amazon analytic tools like Amazon Redshift Spectrum, Amazon Athena etc.• Implemented data lake creation in AWS using Talend big data tool.• Extensively used all the redshift and big data related components like HIVE, HDFS and s3 components.• Extensively work on Talend Spark to extract the data from complex XML and load into a CSV file on s3 so it can be queried for data discovery using Amazon analytic tools like Amazon Redshift Spectrum, Amazon Athena etc.• Implemeted data lake creation in AWS using Talend big data.• Communicate insights and recommendations to leadership and clients

• Interaction with the Business analyst, Business Users and Solution Architects to understand existing application and the new Requirements• Build complex ETL mappings and jobs using Informatica power center and Informatica MDM.• Evaluate and integrate date from various data sources like Oracle, SQL server, VSAM and sequential files into staging area.• Develops ETL processes using Informatica, ETL control tables.• Implement error logging, auditing and data quality checks.• Implement Informatica design components like Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.• Work on data warehouse technologies including ETL Data transformation, Data modeling and Data Aggregation.• Work on Master data management(MDM) and define the match and merge rules in the data model for consolidation of duplicate customers into a single golden record across ERP’s within the organization• Develop source to target mappings.• Develop test scripts and UNIX shell scripts• Administering, optimizing and maintaining ETL environments.• Leverage industry standard data models.• Develop ETL implementations in a very high volume environments using ETL tools and Reporting Tools.• Design and deploy the data model in Talend MDM and make any ongoing modifications needed.• Created complex Informatica mappings using various transformations like rank, expression, joiner, sorter, normalizer, xml generator, Update Strategy, connected and unconnected lookup, Router and Sequence generator following existing ETL standards.• Work extensively on slowly changing dimensions type 1 and type 2 to store both current and historical data.• Design Mapplets & reusable transformations to use them in different mappings.• Create various Informatica tasks such as Sessions, Email, Decision, Control, Command, Timer, Assignment, Event Wait and Event Raise. Used UNIX Shell Scripts for processing the jobs.

Master'S Degree

Bachelor'S Degree