We provide IT Staff Augmentation Services!

Etl Developer (informatica/teradata/autosys) Resume

SUMMARY:

  • IT Professional with over 5+ years of experience and extensive knowledge in Analysis, Design, Development, Testing of ETL process and Implementation of Data Warehouse applications using Informatica Power Center (PC), Informatica Data quality (IDQ), Test Data Management (TDM), Data Sub setting, Oracle and UNIX in industry verticals like financial, Banking and Insurance.
  • Developed the ETL process using Informatica 10.1/9.6.1 along with Perl Scripting to avoid creating multiple Autosys Jobs.
  • Create various python modules to enhance ETL process.
  • Experience in developing web applications by following Model View Control (MVC) Architecture using server - side applications Django, WebPy.
  • Experience in various stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) with implementation knowledge of Waterfall and Agile methodologies
  • Extensively worked on data extraction, transformation and loading data for data warehousing using SQL server, DB2, Oracle and Informatica.
  • Responsible for all activities related to the development, implementation, administration, testing and support of ETL processes for large scale data warehouses using Informatica Power Center 8.x/9.x/10.x and Informatica Data Quality 9.5.1/9.6.1
  • Analyzed the data models of the source systems to develop comprehensive mapping specifications, created POC’s to prepare high level design, mapping specification, Low level design, unit testing plan, monitoring and resolving production issues.
  • Extensive experience working in agile methodologies.
  • Extensively worked with facets of the Informatica power center tool and developed complex mappings on Informatica Power Center, used many Transformations.
  • Experience with IDQ transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
  • Worked on refactoring the code (JSP and JavaScript) by restructuring it for better performance.
  • Proficient in Front end development experience using Python 3.4/2.7, Django 1.7/1.8, HTML, XML, CSS, JavaScript, Bootstrap, JSON and, Angular.js, Node.js.
  • Good knowledge of web services with protocols SOAP, REST and knowledge of server Apache Tomcat, Web logic.
  • Implemented user interface guidelines and standards throughout the development and maintenance of the website using the HTML, CSS, JavaScript.
  • Hands on experience in SVN, Git, JIRA worked in SQL databases MS SQL, Oracle.
  • SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance.
  • Experience in creating Reusable tasks (Sessions, Commands and Email) and Non- Reusable tasks (Decision, Timer, Assignment, Worklets, and Control).
  • Proficient in writing unit testing code using Unit Test/PyTest and integrating the test code with the build process.
  • Worked on Python frameworks like Quartz framework (Internal tools of banking application).
  • Created Autosys jobs for scheduling and aware of all the command line syntax for the same.
  • Used SQL to store multiple commands which can be accessed through the Perl scripting file to directly run the commands for the data extraction process.
  • Also used XML validation and JSON to validate the data before providing it to the end users.
  • Worked on AngularJS to create a web-based report system and to create the Info Quality tool to create different runs and rules related to each of these runs.
  • Having experience in Agile Methodologies, Scrum stories and sprints experience in a Python/Java based environment, along with data analytics and Excel data extracts.

TECHNICAL SKILLS:

ETL Tools:: Informatica Power Center 10.x/9.x/8.x, TDM, IDQ 9.6.1/9.5.1

Databases:: Oracle 11g, 10g/9i/8i, MS Access, SQL server 2005/2008, My SQL, Netezza, Teradata

Database Tools: TOAD, Teradata SQL Assistant, Oracle SQL developer, SQL *PLUS

Programming: C/C++, Java (Intermediate), Python, Visual Basics, Perl Scripting, Java Scripts, Angular, HTML, CSS, Bootstrap, Quartz, Android Development.

Databases and Servers: MySQL, SQL server, Oracle 9i, Oracle 11g, MySQL, Teradata, Apache Tomcat, Net Beans (Glassfish Server).

Tools: Eclipse, Android (XML), Microsoft Office, Visual Studio, Informatica, Autosys, WEKA.

Reporting Tools: Tableau, XmdvTool, D3.

OS: UNIX/Linux, Windows.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer (Informatica/Teradata/Autosys)

  • Working on the product data from Confidential, which involves data about Purchase, Sales and cross border data.
  • Created mappings to load the data to the stage tables and created a new process to handle the hourly pull request for these data.
  • Used different types of transformations to build the mappings to handle the data discrepancy.
  • Used Teradata for working on DDL and DML changes and handle huge dataset request flowing every hour.
  • Created stored procedures, tables, views using Teradata to process million rows data.
  • Suggested new changes to the process and split up the processes to work independently.
  • Using the major ETL tool - Informatica, along with the other tools and using the Teradata interface to work efficiently in such a huge Data Warehouse.
  • Tuning of the mappings and SQL Scripts for a better performance and designed the table structure to validate the process runtime.
  • Testing ETL applications following all ETL standards and architecture
  • Worked with Informatica 10.1.2, created new control workflows to handle all the dependency and created a process to accommodate hourly changes in data.
  • Created the Autosys jobs, to make the data pull run independently.
  • Worked on scheduling jobs in Autosys tool to schedule the workflows and work on their dependencies.

Tools: Informatica Power center 10.1, Teradata, Autosys.

Confidential

ETL Developer/Tester (Informatica/IDQ/SQL Server)

  • Working on the health insurance details from client and creating mappings and workflow.
  • Created mappings as per the requirements to load data into the SQL Server Tables.
  • Used different types of transformations to build the required logic.
  • Created Tables, Keys (Unique and Primary) and Indexes in SQL Server Tables.
  • Tuning of the mappings and SQL Scripts for a better performance.
  • Using the major ETL tool - Informatica, along with the other tools and using the SQL Server interface to work efficiently in such a huge Data Warehouse.
  • Created Tables, Keys (Unique and Primary) and Indexes in SQL Server Tables.
  • Tuning of the mappings and SQL Scripts for a better performance.
  • Testing ETL applications following all ETL standards and architecture
  • Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, reporting and monitoring capabilities of IDQ 9.6.1.
  • Created the batch control process, to debug the workflows in sequential order and avoiding the sessions which have already been run.
  • Worked on scheduling jobs in Control-M tool to schedule the workflows and work on their dependencies.

Tools: Informatica Power center 10.1, IDQ 9.6.1, Control-M, SQL Server, Visual Studio.

Confidential

ETL Developer/QA (Informatica/Oracle/JavaScript/Angular)

  • Created web dashboard tool which delivers real time data analysis and reports of the data required from upstream/downstream with number of validations in place using Angular, JavaScript, HTML, CSS and Bootstrap.
  • Built a complete new UI page for user to reduce the manual intervention and provide them with auto-populated fields to make the rule writing piece easier.
  • Developed UI in Quartz tool (Python) for user to easily differentiate the run details of all the processes and to even provide notifications if the job have failed or not ran to complete the process.
  • Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, reporting and monitoring capabilities of IDQ 9.6.1.
  • Analyzed business requirements and features required for tool to analyze, monitor, control and report business data.
  • Performed data warehouse concepts and extract, transform and load (ETL) data process.
  • Working as a technology associate in CIDW ( Corporate Investment Data Warehouse) to execute the ETL process on the bank data for all Banking Specific datasets.
  • Using the automation tool like Autosys along with the scripting language like Perl and also using Python which helps in major enhancement for the data to be processed and delivered.
  • Using the major ETL tool - Informatica, along with the other tools and using the Oracle and SQL interface to work efficiently in such a huge Data Warehouse.
  • Used different types of transformations to build the required logic.
  • Created mappings and scheduled them as per the dependency to deliver data to the users as per the SLA timings.
  • Transformed the SLA tracking tool.
  • Transformed the multiple Autosys jobs dependency in a dynamic manner using the database to call only few jobs and handled all the dependency using the database.
  • Wrote the SQL queries & PL/SQL code on EDW tables and Data Mart Staging Tables to validate the data results.
  • Performed automation Unit testing using Ruby mine tool.
  • Automated the test scripts from Landing Database to Staging area and from staging area to Enterprise Datawarehouse.
  • Used Agile methodology and have completed Agile scrum workshops.
  • Learning about the banking business terms and understanding all the different types of regulatory reports to be delivered for all the Federal Analysis and Risk management.
  • Imported all the data from SQL database for the dashboard and gave users the functionality to update for any data discrepancies.
  • Used Autosys scheduling tool to run the dashboard as per the live updates and specific key functionality like SLA tracking was also been monitored in the dashboard.

Tools: Informatica 10.1/9.6.1, Autosys, AngularJs, Oracle, Javascript, MySQL, Python, UNIX, Perl Scripting, PL/SQL, Java, HTML, CSS.

Hire Now