Looking for Sr. Cognos TM1 Developer and Data Quality Engineer
Rahul Teja
Please check the following requirement and share your consultant resumes to email: ra...@lor-venk.com / 804-554-1121 or 919-689-5606.
1)Role: Sr. Cognos TM1 Developer
Location: Jersey City NJ
Client: Sumitomo
Duration: Long term
Any visa is accepted (OPT, CPT, H1B, H1B Transfer, H4-EAD, GC-EAD, E3 ,L1,L2-EAD,USC and GC)
- Implements changes consistent with business requirements and within established timelines.
- Interprets business requirements and produces information objects to support those requirements.
- Creates and maintains appropriate documentation - designs and implements standards.
- Develops queries, reports, packages, cubes, and other end user applications to meet the needs of the business.
- Uses appropriate tools and technologies to develop and test the logic changes needed by various applications programs.
- Troubleshoots and provides user support for data analytic issues by reviewing program code and data source for flaws in design or integrity.
- Develops and expands knowledge of relevant tools and technologies.
- Uses the Software Development Life Cycle (SDLC) methodology to deliver Business Intelligence and Analytics projects through requirements gathering, scope definition, development, testing, and implementation.
- Enhance or maintain existing applications, and the analysis of data problems and implementation of fixes for defects reported in various applications.
Required Technical Skills:
- Strong problem solving, diagnostic, and analytical skills including; ability to relate numbers and calculations to ideas.
- Proficient in the use of Microsoft Office Suite of tools.
- Proficient with Business Intelligence tool sets, primary Cognos.
- Experienced with Business Intelligence tool sets (Power BI and TM1).
- Familiar with Guidewire Policy Administration System (Policy Center, Billing Center, Claims Center, EDW)
- Familiar with some programming languages (example: SQL, HTML, CSS, Java Script, jQuery, Java, and Batch Program).
- Familiar with gathering data using Structured Query Language (SQL).
- Familiar with logical and/or physical data modeling techniques.
- Familiar with Data Warehousing and/or Business Intelligence and Analytics tools, technologies, testing, project lifecycle (SDLC), and best practices.
- Proficient in translating functional business requirements to technical specifications.
2)Role: Data Quality Engineer
Location: New Jersey NJ
Client: Sumitomo
Duration: Long term
Any visa is accepted (OPT, CPT, H1B, H1B Transfer, H4-EAD, GC-EAD, E3 ,L1,L2-EAD,USC and GC)
Responsibilities:
· Design, develop and maintain data quality assurance framework
· Work in conjunction with BI and Data Engineers to ensure high quality Data Deliverable
· Design and develop testing frameworks to test ETL jobs, BI reports and Dashboards and other data pipelines
· Write SQL scripts to validate data in the data repositories against the data in the source systems
· Write SQL scripts to validate data surfacing in BI assets against the data sources
· Ensure data quality by checking against our ODS and the front-end application
· Track, monitor and document testing results.
Requirements:
· Bachelor's in Computer Science or a related field (hands-on experience trumps)
· 2+ years of experience as a Data Engineer or a related role
· Demonstrated ability to write complex SQL/TSQL queries to retrieve/modify data
· Ability to work in an Agile environment
· Ability to learn new tools and technologies and adapt to an evolving tech-scape
Nice to have:
· Master’s in Management Information Systems or similar
· Knowledgeable in Data Modeling and Data warehouse concepts
· Experience with visualization tools such as Power BI, Tableau, SpotFire, TIBCO, QlikView, MicroStrategy, Information Builders, and other reporting and analytical tools is a plus