Software Developer 100522
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. Email: resumes@ritepros.com