What are the responsibilities and job description for the SSIS/SSRS Developer position at Codeforce 360?
Job Description
Career Opportunity:
Job Title: SSIS/SSRS Developer
About CodeForce 360
Making a career choice is amongst the most critical choices one can make, and it's important for the choice to be calculated with factors such as a company's run of success since its inception and more. But, when you come across a company that has reputation proven with nothing but an illustrious run of success since the day it began, you don't need to think of anything else. That's precisely what some of our employees and prospective employees think when they came across CodeForce 360.
Position Overview
SSIS/SSRS Developer
Requirements:
- Develops, tests, manages, and implements ETL packages and applications within the standards set by the team.
- Performs standard ETL administration tasks such as deployment, package migration and relocation, and managing metadata.
- Prepares ETL packages for deployment to development, test, and production environments following all Release Management policies.
- Solutions complex ETL-related technical tasks, identifies potential issues, resolve issues, and drives tasks to successful completion on or ahead of schedule.
- Solves complex issues in innovative ways.
- Tunes and troubleshoots ETL applications.
- Understands processes and procedures and advocates for their use with all project members both inside and outside the ETL team.
- Involved in relational data modeling and multi-dimensional modeling using de-normalizations, fact tables, dimension tables, star schema
- Mentors other team members in areas of expertise and ETL processes and standards and participates in code reviews
- Informs Management of project issues; escalates issues in a timely manner, and asks for assistance when needed.
- Multi-tasks simultaneous assignments, prioritizing ETL tasks, ensuring all tasks are completed on or ahead of schedule
- Automates processes where appropriate.
- Participates in the on-call rotation.
Knowledge, Skills and Abilities (List all knowledge, skills and abilities that are necessary to perform the job satisfactorily)
- Analytical skills in a SQL Server environment
- ETL design and development knowledge using the Microsoft BI tool set, specifically SSIS
- Database knowledge SQL Server required, Oracle a plus
- Experience using SSRS for reporting
- Experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012 for both OLTP & Data warehousing applications in various business domains.
- Knowledge of Linux/Unix environment a plus
- Knowledge of Informatica ETL tool a plus
- Healthcare industry background a plus.
- Excellent verbal and written communication skills
- Ability to maintain attendance to support required quality and quantity of work
- Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)
- Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers
Required Experience:
- 5 years ETL design and development experience
- 5 years Analysis experience
- 5 years database knowledge utilizing SSIS
- 3 years knowledge utilizing SSRS
How to Apply
Job ID: JPC - 168083
For more information, please contact below:
Ayush Mahar
(470) 297-0463
ayushm@codeforce.com
Qualified individuals will be contacted for an interview.