Contact us for help?

Contact with us through our representative or submit a business inquiry online.

Contact Us

Software Developer

Software Developer with Bachelor’s Degree in Computer Science, Computer Information Systems, Information Technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.

Job Duties and Responsibilities:

  • Requirements gathering and analysis by constant interactions with business team and with the client architects.
  • Project planning and tracking the activities.
  • Create and maintain conceptual, logical & physical Data model by understanding business data relationships.
  • Create mapping documents, ETL design (HLD, LLD) documents and provide estimations.
  • Work allocation within the team members, mentoring other ETL developers.
  • Provide technical assistance, troubleshooting and identifying alternate development solutions.
  • Develop code using PowerCenter Client Tools, Informatica IDQ, Informatica Intelligent Cloud Service (IICS), Oracle, Linux, Control-M and SQL Data Modeler.
  • Extract data from different source systems and load into Data warehousing and Data mart.
  • Develop the mappings, mapplets, tasks, reusable transformations, sessions and Workflows etc.
  • Perform unit testing, integration testing and performance testing.
  • Implement SCD Type 1 and SCD Type 2 mappings to maintain current and historical information in the Data Warehouse.
  • Troubleshoot and provide support during load failures.
  • Identify bottlenecks and implement Performance tuning
  • Prepare release notes, deployment package and deployment tickets.
  • Maintain versioning of each development release in SVN.
  • Design and implement end to end Data Quality strategy including a sustainable Data Quality improvement lifecycle
  • Create Data Quality Scorecards/Reports
  • Perform data profiling and create rules using Informatica Analyst and Informatica Developer.
  • Implement data quality processes using Standardizer, Address validator, Labeler, Match, Association, Parser, Expression, Filter, Router, Lookup transformations etc.
  • Migrate objects from IDQ to PowerCenter or other Informatica tools
  • Perform code review
  • Create new batch jobs and dependencies using Control-M/Autosys.
  • Scheduling batch Jobs, testing it in the test environments and migrate into Production.
  • Monitoring of scheduling and troubleshooting failed jobs and dependencies.
  • Ability to work independently, lead and mentor the team
  • Bring deep knowledge and experience in designing for and implementing solutions in the Cloud (AWS).

Work experience / Skills required for the position:

  • 3+ years of experience in building software applications through ETL based technologies.
  • Experience working with Informatica PowerCenter, Informatica Data Quality (IDQ), IICS, Oracle PL/SQL, Unix scripting and Control-M.
  • Strong experience in relational database concepts, SQL, and procedural languages.
  • Bring deep knowledge and experience in designing for and implementing solutions in the Cloud (AWS).
  • Strong analytical and problem-solving skills as well as the ability to decompose complex problems and perform root cause analyses.
  • Work in a collaborative environment.
  • Experience working with the agile team tools (JIRA, Confluence, Scrum).
  • Good knowledge in Agile/ Scrum and SDLC methodologies.

Technology aspects:

  • Operating System : Windows 7/Windows 10, Unix/Linux
  • ETL and DQ Tools : Informatica 8.x/9.x/10.x, Informatica Data Quality (IDQ) 9.x/10.x
  • Cloud ETL Tool : Informatica CDI(IICS)
  • Cloud Computing : AWS
  • Database : Oracle 10g/11g/12c/19c, MS SQL Server 2008/2019, Sybase ASE 15.0.1
  • Utilities : TOAD, Putty, WinSCP, SQL Developer, SQL Data Modeler, DBArtisan 9.0
  • Languages : SQL, PL/SQL
  • Scheduling Tool : Control-M, Autosys
  • Versioning : SVN
  • Other : Data Modelling, ETL designing

Work location is Portland, ME with required travel to client locations throughout USA.

Rite Pros is an equal opportunity employer (EOE).

Please Mail Resumes to:
Rite Pros, Inc.
565 Congress St, Suite # 305
Portland, ME 04101.