We provide IT Staff Augmentation Services!

Sr Developer / Designer Ny

Summary:

  • 7+ years of software development and sustenance experience which includes design and development of data warehousing projects as ETL Developer/Designer using Informatica, Oracle and UNIX.
  • Strong Skills in Data Warehousing Concepts, Informatica, Oracle, SQL, PL/SQL.
  • Well conversant in Software Development Methodology, analysis, business process, designs, coding and participated in all phases of Software Development Life Cycle.
  • Experience in requirement gathering from business users and provide designing approach to reviewers.
  • Exposure to Health care and financial domains.
  • Capability of deploying projects from development environment into Production.
  • Strong skills in defect resolution.
  • Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
  • Strong knowledge on Audit Balance Framework.
  • Proficient in creating accurate and comprehensive code to meet the business requirements.
  • Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
  • Skilled to provide out-of-the-box approaches to fulfill design requirements within existing technology and process constraints.
  • Provide technical leadership, mentorship, and coaching to team members.

TECHNICAL SKILLS

Technology Tools: Data Warehousing Informatica 7.1.2, 8. 1.1,8.6,9.5

Databases : Oracle 10g /11g(Exadata),MS SQL Server 2005/2008/2012

Languages : SQL, PL/SQL, UNIX Shell Scripting

Verticals: He alth care and Financing

PROFESSIONAL EXPERIENCE

Confidential, NY

Role : Sr Developer / Designer

Responsibilities:

  • Gather requirements and provide efficient designs.
  • Design end-to-end flow to meet LFGD requirements .
  • Develope reusable Informatica mappings, mapplets and sessions for audit balance framework.
  • Worked closely with business for DMD changes.
  • Develop ETLs, Unit Test , Assembly Test and provide support during QA and UAT.
  • Build reusable components wherever possible for better reusability and reduce complexity.
  • Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
  • Prepare Unit test documents , Assembly Test Documents and LLD Documents.
  • For Assembly testing, worked with business to provide and validate the data for business test cases
  • For Assembly testing, create the list of jobs to be executed and the order of execution in Dev to simulate it in Production for Autosys.
  • Co-ordinate with other source systems to load the data for Assembly Testing.
Confidential, New York

Role : Sr Developer / Designer

Responsibilities:

  • Gather requirements and provide efficient designs.
  • Design end-to-end flow to meet Geneva requirements .
  • Develop ETLs, Unit Test , provide UAT /Prod support and handle production release.
  • Deployment of ETL changes to higher environments.
  • Create UNIX scripts for ftp’ing the target files.
  • Build reusable components wherever possible for better reusability and reduce complexity.
  • Use pushdown optimization concept for better performance.
  • Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
  • Leading the ETL Development team

Confidential

Role: Developer/Designer

Responsibilities:

  • Design end-to-end flow for GSL .
  • Develop ETLs, Unit Test and provide UAT /Prod support and handle production release.
  • Deployment of ETL changes to higher environments.
  • Create UNIX scripts for ftp’ing the target files.
  • Build reusable components wherever possible for better reusability and reduce complexity.
  • Used pushdown optimization for better performance.

Confidential, New York

Role : Developer/Designer

Responsibilities:

  • Redesign CRC ABC architecture to fit GSL project.
  • Design end-to-end flow for GSL .
  • Develop ETLs, Unit Test cases and provide UAT /Prod support and handle production release.
  • Deployment of ETL changes to higher environments.
  • Create UNIX scripts for ftp’ing the target files.
  • Build reusable components wherever possible for better reusability and reduce complexity.

Confidential

Role : Developer/Designer

Responsibilities:

  • Involved in all phases of the cycle(Requirement gathering to Production deployment)
  • Design and develop the mappings using different sources like XML, COBOL, Flat files, Oracle, SQL Server, and Message Queues etc.
  • Design and develop reusable components.
  • Automate some of the processes in the project.
  • Design, Cod e, Unit Test , provide UAT /Prod support and handle production release.
  • Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
  • Deployment of ETL changes and DB changes to higher environments.
Confidential

Role : Informatica Developer

Responsibilities:

  • Analyse the Business Requirements Documents.
  • Design and d evelop the mappings/workflows as per the high level ETL architecture.
  • Prepare unit test cases.
  • Design and develop reusable components to reduce complexity and encourage reusability.
  • Involved in Unit Testing and Performance tuning of both Informatica mappings
  • and database queries.
  • Writing stored procedures and shell scripts.

Hire Now