Datrose New York , NY 10007
Datrose is seeking an experienced ETL Developer for an excellent temporary assignment (W2 Only) opportunity in New York, NY! This is an excellent opportunity for the right individual. If interested in exploring this great opportunity, please apply directly at www.datrose.com/careers.
At least 4 years of working experience in programming and functional requirements.
Strong knowledge of XML technologies (XML, XSL, XSD)
Ability to write complex ETL procedures using SQL / T-SQL. Experience working with complex SQL and its variations (such as PL/SQL) is an asset.
Hands on knowledge of SQA, PKI, web services, Enterprise Service Bus technologies.
Expertise with integration technologies and processes, enterprise data warehouse implementations and reporting tools, integrating multiple legacy and strategic systems.
Solid understand of enterprise service bus concepts.
Knowledge of testing tools and techniques and executing test scripts to test performance of ETLprocedures.
Significant experience in development, maintenance, and enhancements of informatica Mappings, Work-flows, and processes.
Knowledgeable in several multi-dimensional and data mining techniques such as EDW, ODS, DM, ROLAP and MOLAP.
Experience with Informatica and TM1 Turbointegrator.
Proficient with Cognos, including Facts, Dimensions & Various Schemas supporting them.
Strong written, verbal and interpersonal skills..
Excellent analytical, organization, presentation and facilitation skills; ability to handle multiple tasks under tight deadlines.
Knowledge of database administration, repository management, and data warehousing practices.
Familiarity with New York Citys data share platforms, including Open Data (DoITTs DataShare) (FMS, PIP, VENDEX, APT HHS Accelerator).
Working knowledge of database front-end systems, including MS Access.
Working knowledge of database back-end systems, including SQL Server 2008 R2 / 2012. Experience in object-oriented languages (i.e. Java, C#, etc.)
Experience in scripting languages (i.e. VBA, PowerShell, etc.)
Past utilization of code repositories including, GitHub, Bitbucket, or GitLab.
Use of software development collaboration tools, including Jira, Slack, Team Foundation, and Base Camp.
Datrose is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, protected veteran status, or status as a qualified individual with disability.